[Zope-DB] RE: Debug SQL queries

[Andreas Tille]

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

         Andreas.