[Zope] ZSQL method LAST_INSERT_ID() error

Andy Dustman andy@dustman.net
Tue, 13 Mar 2001 10:59:16 -0500 (EST)


http://www.zope.org/Members/adustman/Tips/no_limits

On Tue, 13 Mar 2001 paul_s_johnson@urscorp.com wrote:

> 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?

-- 
Andy Dustman         PGP: 0xC72F3F1D
    @       .net     http://dustman.net/andy
"Normally with carbonara you use eggs, but I used lobster brains instead."
    -- Masahiko Kobe (Iron Chef Italian): 30-year-old Giant Lobster Battle