Re^2: prepare statement within DBI

You don't need DBIx::Simple to simplify that. Just do this with plain old DBI:

  $row1 = $dbh->selectrow_array('select count(*) from table_one');
  $row2 = $dbh->selectrow_array('select count(*) from table_two');
[download]

Comment on Re^2: prepare statement within DBI Download Code

Replies are listed 'Best First'.
Re^3: prepare statement within DBI by Juerd (Abbot) on Aug 27, 2004 at 05:35 UTC
You don't need DBIx::Simple to simplify that. Just do this with plain old DBI Yes, but with one important difference: selectall_array prepares a new sth each time, while DBIx::Simple re-uses them (as if prepare_cached were used, but safer). Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }	[reply]