This was written in 2002 and may no longer be accurate.

I entered this SQL statement on the Zope Test page:

SELECT * FROM <table>;

Zope produces this error:

Error Type: OperationalError
Error Value: (1064, "You have an error in your SQL syntax near '; LIMIT 1000' at line 1")

Here's what's going on: the SELECT statement is valid SQL; however, it's not valid Zope. Use <dtml-var sql_delimiter> instead of a semicolon (;) to separate multiple SQL statements in the same Z SQL Method.