Z SQL Method - Test: Test the validity of your SQL statement
Description
Test a SQL method.
Controls
-
*[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.