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

Jorge O. Martinez jmartinez@eMediaMillWorks.com
Thu, 18 Apr 2002 10:25:49 -0400


I'll try that. If I can see the 'bad' query in logs will help.

Regards,

Jorge M.

Stuart Bishop wrote:
> 
> 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/
> 
> 
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
> 



-- 
Jorge O. Martinez
MIS Senior Associate
eMediaMillWorks
1100 Mercantile Lane, Suite 119
Largo, MD 20774
E-mail  => jmartinez@eMediaMillWorks.com
Phone   => (301)883-2482 ext. 105
Fax     => (301)883-9754