[Zope] Viewing SQL code being run

[Jon Erickson]

The zsql methods' "Test" tab is your friend.  It will show you the
results of the query as well as the actual SQL statement that was
executed.  It's an invaluable tool while debugging complex SQL
statements.

On Fri, 2002-06-28 at 11:31, Ed Leafe wrote:
> 	I'm learning to use sqlgroup to eliminate a lot of nearly identical 
> queries, and so far have been happy with the results. But every so often 
> I get a result that doesn't jibe with what should be returned, and I'm 
> having a hard time figuring out where my mistake is.
> 
> 	Is there any way to view the actual SQL that gets sent to the 
> server after all the sqlgroup and sqltest tags are evaluated? That would 
> be a really big help in debugging complex expressions.
> 
>       ___/
>      /
>     __/
>    /
>   ____/
>   Ed Leafe
>   http://leafe.com/
>   http://foxcentral.net
> 
> 
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>