[Zope] Allowed SQL statements for ZSQL

Martin Gebert Murphy@members.netsolution-net.de
Tue, 21 Jan 2003 12:52:27 +0100


Martin Gebert schrieb:

> That's right, and sometimes this causes problems with specific SQL 
> statements, e. g. when setting locks (explanation: LIMIT as inserted 
> where the MySQL parsed doesn't expect it, so it's a syntax error). Go 
> to the "Advanced" tab ot the Z SQL method and set the Limit to 0.

Uh oh, Ten-left-thumbs-Martin strikes again ;-\ The above should read

[...] (explanation: LIMIT _is_ inserted where the MySQL _parser_ doesn't 
expect it, so it's a syntax error). Go to the "Advanced" tab _of_ the Z 
SQL method [...]

Martin