-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I would like to suggest a new feature/function in DBI. It would really
> be nice if there was a way to print out the actual sql statement for
> debugging purpose, in particular in cases with placeholders like this
> example:

I'm not really seeing the advantage of this - such a low-level debugging
belongs in your database server logs. However, many of the drivers
already do print out some version of what you want - try calling
$dbh->trace(15) and see what happens. In the future, there will also
be finer control over the trace messages so that you could only see
the parts of the trace you were interested in.

I cannot speak for the other drivers, but what you want will likely never
happen in DBD::Pg, as it does not send an "actual sql statement" to the server
anymore, but sends the prepared statement, and then an array of values with
each execute, plus an array of lengths if the data is binary.

- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200604130119
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFEPd+xvJuQZxSWSsgRAtaaAKDrb3wQydJxgU8i9e10wUffn36duACfQaAN
qGNG1cN/DuEv6lddTbBEUtQ=
=eid8
-----END PGP SIGNATURE-----


Reply via email to