Z SQL Method - Test: Test the validity of your SQL statement


Test a SQL method.


*[arument names]*
There will be one text field for each argument specified for the SQL method. The text field will contain the default value. Important: You must enter a value matching the specified argument type, otherwise a "Type Error" is returned.
Submit Query
Causes the query to be executed and the results are returned as an HTML table. If the query was had a syntax error or the accessed table did not exist, a database-specific error message is returned in form of an exception.

If you have a SQL statement that does not return any data, Zope will tell you that this SQL statement was not a query and will not display any results.