How can I display the full text of a query created by PDO?

Question

I'm creating a SQL query with PDO in PHP. Unfortunately, there seems to be an error in my query. I've tried $query->errorInfo(), but that only gives me a little bit of the error message ("There is an error in your syntax near...").

How can I display the entire query that PDO is passing to my database?

TIA.

Answer 1

You can't really. This has been discussed here before, see this:

http://stackoverflow.com/questions/210564/pdo-prepared-statements