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 )