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
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 )
Ed Leafe writes:
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. Someone else already told you about the "Test" tab of ZSQL methods.
In cases, this is not feasible, you can call a ZSQL method with an "src__=1" keyword parameter. In this case, it will just generate the SQL command and return it. It will not send the generated SQL to the database. Dieter
participants (3)
-
Dieter Maurer -
Ed Leafe -
Jon Erickson