[Zope] Z SQL Methods and the SQL LIMIT clause

[Andy Dustman]

On 5/11/05, Asad Habib <ahabib at engin.umich.edu> wrote:
> Is there a reason why Z SQL methods do not allow the use of the LIMIT
> clause? I am absolutely certain that my query has the right syntax since I
> executed it against the MySQL server and it gave me the correct results.
> FYI, I have provided the query below:
> 
> SELECT course_id FROM course
> WHERE course_id < 991000
> ORDER BY course_id DESC LIMIT 1
> 
> Furthermore, Zope throws the following error when I try to test this query
> via the ZMI and also when I use it in my application:
> 
> (1064, "You have an error in your SQL syntax; check the manual that
> corresponds to your MySQL server version for the right syntax to use near
> 'LIMIT 1000' at line 3")

LIMIT is not a standard SQL clause. ZMySQLDA uses it internally, based
upon the max_row properties of the Z SQL Method. If you want to use
it, get rid of the LIMIT clause in your query, and set the max_rows
property accordingly. Also, you can "trick" ZMySQLDA into not adding a
LIMIT by putting a comment before your SQL statement.

http://www.zope.org/Members/adustman/Tips/no_limits
-- 
Computer interfaces should never be made of meat.
http://www.terrybisson.com/meat.html