Help for this page

Select Code to Download


  1. or download this
    my $filter = "('Y' || 'N')";
    my $sth = $dbh->prepare(q{SELECT name FROM catagories WHERE catagories
    +.workrelated = ? ORDER BY name});
    $sth->execute($filter);
    
  2. or download this
    my $sth = $dbh->prepare(q{SELECT name FROM catagories WHERE catagories
    +.workrelated = ? ORDER BY name});
    $sth->execute("('Y' || 'N')");
    
  3. or download this
    my $sth = $dbh->prepare(q{SELECT name FROM catagories WHERE catagories
    +.workrelated = ('Y' || 'N') ORDER BY name});
    $sth->execute();