[Zope-DB] RE: Debug SQL queries

Andreas Tille tillea at rki.de
Tue Sep 23 08:39:41 EDT 2003

On Wed, 17 Sep 2003 jwsacksteder at ramprecision.com wrote:

> >ZSQL Method's "__call__" has an "src__" parameter. When you
> >pass a true value, the method returs the generated SQL source
> >(without executing it).
Another possibility is to just

    revoke all on <table beeing accessed> from zope ;

and do the query again.  The error message will show the string which Zope
was not able to execute successfully.  It's kind of a hack but works without
extra Zope programming.

Kind regards


More information about the Zope-DB mailing list