[Zope] ZSQL method LAST_INSERT_ID() error

paul_s_johnson@urscorp.com paul_s_johnson@urscorp.com
Tue, 13 Mar 2001 09:02:52 -0600


This ZSQL query:

     SELECT LAST_INSERT_ID() AS ID

Is returning this error:

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

It apparently automatically adds a LIMIT clause to the end of my SQL query
that MySQL does not like in this context.  Is there any way to shut the
limit clause off?  Anybody have any ideas for a workaround?

P. Johnson