Re: Output results from a DBI select query in one line

Why not just:

$_->execute(4, 5), $_->dump_results for $dbh->prepare(q{
  SELECT one, two FROM three WHERE four = ? AND five = ?
});
[download]

Comment on Re: Output results from a DBI select query in one line Download Code

Replies are listed 'Best First'.
Re^2: Output results from a DBI select query in one line by jZed (Prior) on Apr 11, 2006 at 18:09 UTC
Or, a couple of characters shorter than that (if we don't count loading Dumper): `print Dumper $dbh->selectall_arrayref("SELECT one, two FROM three WHER +E four=? AND five=?",{},4,5);` [download]	[reply] [d/l]
Re^3: Output results from a DBI select query in one line by mjg (Scribe) on Apr 11, 2006 at 18:30 UTC
Either merlyn's or jZed's examples are fine for diagnostics. The original, however: won't truncate values as `dump_results` does provides more human-readable output than Data::Dumper's structures But feel free to use whatever works for you. Mine was just more appropriate for my project.	[reply] [d/l]