Help for this page

Select Code to Download


  1. or download this
    my $results = $dbh->selectall_arrayref(<<'SQL',{ Slice => {} }, $place
    +holder1, ... );
        SELECT foo
             , bar
          FROM mytable
    SQL
    
  2. or download this
    my $sql = <<'SQL';
        SELECT foo
    ...
    SQL
    $app->log($sql);
    my $results = $dbh->selectall_arrayref($sql,{ Slice => {} }, $placehol
    +der1, ... );
    
  3. or download this
    my $sql = <<'SQL';
        SELECT foo
    ...
    SQL
    # $app->log($sql);
    my $results = $dbh->selectall_arrayref($sql,{ Slice => {} }, $placehol
    +der1, ... );
    
  4. or download this
        while (my ($name,$value) = each %$parameter_names) {
            (my $perl_name) = ($name =~ m!(\w+)!);
    ...
            }
            $sth->bind_param($name => $parameters->{$perl_name}, $type)
        };