[Zope] Using LIMIT in a SQLMethod

Harald Stowasser Stowasser.h@idowa.de
Fri, 09 Feb 2001 10:02:21 +0100


Hello, i want to use the LIMIT funktion from MySql with a ZSQLMethode.
But i'll get an error. Becourse ZSQL makes a second LIMIT in the
SQL-string (options in 'Advanced')

See, i will do:

SELECT * FROM thema
WHERE FK_forum_id=1
LIMIT 10,50

But it raises that:

Fehler in der Syntax bei 'LIMIT 1000' in Zeile 6
(Error in Syntax by 'LIMIT 1000' at line 6)

What can i do?