[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