On 5/11/05, Asad Habib <[EMAIL PROTECTED]> 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.

Computer interfaces should never be made of meat.
Zope maillist  -  Zope@zope.org
**   No cross posts or HTML encoding!  **
(Related lists -
 http://mail.zope.org/mailman/listinfo/zope-dev )

Reply via email to