[Zope-DB] How to view a dynamically generated ZSQL query

Stuart Bishop zen@shangri-la.dropbear.id.au
Thu, 18 Apr 2002 12:08:15 +1000


On Thursday, April 18, 2002, at 12:43  AM, Jorge O. Martinez wrote:

> Stuart:
>
> 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 
inside
a <dtml-log></dtml-log> pair. The generated SQL will then go to your log 
files
instead of being executed.


--
Stuart Bishop <zen@shangri-la.dropbear.id.au>
http://shangri-la.dropbear.id.au/