Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re: Get a hash object from a database with DBI for use with HTML::Template

by Cine (Friar)
on Aug 04, 2002 at 14:36 UTC ( #187489=note: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
        my $stmt = "SELECT * FROM $table WHERE $key_col = '$key_val'";
        my $sth = $dbhandle->prepare( $stmt );
        $sth->execute();
    
  2. or download this
        my $stmt = "SELECT * FROM $table WHERE $key_col = ?";
        my $sth = $dbhandle->prepare( $stmt );
        $sth->execute($key_val);
    
  3. or download this
        my $ref = $sth->fetchall_arrayref();
        $sth->finish();
        return map { $_->[$name_col] => $_->[$val_col] } @$ref;
    
  4. or download this
        my $ref = $sth->fetchall_hashref([$name_col,$val_col]);
        $sth->finish();
        return map {@$_} @$ref;
    
  5. or download this

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://187489]
help
Chatterbox?
[erix]: yeah... trepidation
Corion quivers with antici...
[choroba]: if you turn off autocommit and run a prepared statement which fails, the transaction is automatically rolled back, at least in DBD::Pg
[erix]: at least, I'll know where to find the documentation :P
[choroba]: but if there's no prepared statement, there's no rollback
[choroba]: the rollback happens when deallocating the prepared statement in error state.
[choroba]: is this something that Pg enforces, or just a consequence of the Perl implementation?
[choroba]: also, does it make any sense? We run different statements generated from input structures, sometimes prepared statements are involved, sometimes not. We want the behaviour to be consistent.

How do I use this? | Other CB clients
Other Users?
Others cooling their heels in the Monastery: (14)
As of 2017-09-19 12:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    During the recent solar eclipse, I:









    Results (220 votes). Check out past polls.

    Notices?