James Merchny wrote:Sure...and I am doing that. But to wrap a bit of text in quotes thirty times just makes me wonder if there is not a better way.
Also, trying to debug the SQL statement is a challenge. I cannot find a way to examine the "updated" statement just prior to execution, other than drilling down through a coupld of layers of watches.
Yep. I hate that. A long time ago I found a library that could parse the prepared statement and show you the actual SQL you end up with.
Obviously, it is only for debugging as it kind of defeats the purpose of prepared statements.
I posted on my blog about it a long time ago, here it is:
http://www.phpsolvent.com/wordpress/?p=198
(note that my version of the library is no longer available)