[Zope-DB] How to view a dynamically generated ZSQL query
Thu, 18 Apr 2002 12:08:15 +1000
On Thursday, April 18, 2002, at 12:43 AM, Jorge O. Martinez wrote:
> Thanks a lot; it's almost what I need, but it's only displaying the SQL
> being used if the query is executed successfully, but if the query
> fails I only get the Oracle error, it's not showing me the query that
> caused it (which is what I need to have to figure out what's wrong). I
> could figure out the problem the long way, but it would have helped to
> see the bad query.
Hmm... I was under the impression that it didn't execute the query.
The other way is to install the Logger product, and enclose your query
a <dtml-log></dtml-log> pair. The generated SQL will then go to your log
instead of being executed.
Stuart Bishop <email@example.com>