Help for this page

Select Code to Download


  1. or download this
    my $sql = "SELECT DISTINCT id FROM mytable WHERE active = ?";
my $ref =  $dbh->selectall_arrayref($sql,undef,'yes');
@id = map{ $_->[0] } @$ref;
die join (", ", @id), "\n";
  2. or download this
    my $sql = "SELECT DISTINCT id FROM mytable WHERE open = ?";
my $ref =  $dbh->selectall_arrayref($sql,undef,'true');
@id = map{ $_->[0] } @$ref;
die join (", ", @id), "\n";
  3. or download this
    'open'
'\open\'
...

\'\"open\"\'
\"\'open\'\"