Help for this page

Select Code to Download


  1. or download this
        my $sth = $dbh->prepare_cached( $sql );
        $sth->execute( @bind_vals );
        $result = $sth->fetchall_hashref( $name );
        $tt->process("result.tt", { result => $result })
    
  2. or download this
        my ( %row , @rows );
        $sth->bind_columns( \( @row{ @{$sth->{NAME_lc}} } ) );
    ...
            push @rows, \%row_copy;
        }
        $tt->process("result.tt", { result => \@rows })