Re^2: DBI - Get prepared/populated sql statement

in reply to Re: DBI - Get prepared/populated sql statement
in thread DBI - Get prepared/populated sql statement

That works great. Thanks!

Oops. I spoke too soon. $dbh->{Statement} gives only the raw query. For debugging purposes, I'd like to have the query which has been populated with arguments from $dbh->execute(). Oh well....

Comment on Re^2: DBI - Get prepared/populated sql statement Select or Download Code

Replies are listed 'Best First'.
Re^3: DBI - Get prepared/populated sql statement by mje (Curate) on Mar 11, 2009 at 12:02 UTC
See http://search.cpan.org/~timb/DBI-1.607/DBI.pm#ParamValues_(hash_ref,_read-only) for ParamValues which you can use to get at your parameters. Shameless plug - if you want more debugging of SQL and DBI method calls, try http://search.cpan.org/dist/DBIx-Log4perl/.	[reply]

In Section Seekers of Perl Wisdom