[Zope] LAST INSERT ID driving me crazy

[robert rottermann]

Alric Aneron wrote:
> Hi guys,
> HOW HOW HOW HOW!!!
> Do I get at the last_insert_id() function, this is driving me 
> absolutely crazy!!
> Zope docs say use "select last_insert_id()" but it doesn't work, gives 
> me an error about bad SQL syntax around "LIMIT 1000".  I tried 
> googling it, I tried searching through other docs.   And it just won't 
> do it!
>
> I would like to make a separate ZSQL Method that will return to me the 
> last insert id.
>
> Any help would be appreciated.
>
> Thank you.
>
> ------------------------------------------------------------------------
> Yahoo! Messenger with Voice. Make PC-to-Phone Calls 
> <http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com> 
> to the US (and 30+ countries) for 2¢/min or less.
> ------------------------------------------------------------------------
>
> _______________________________________________
> Zope maillist  -  Zope at zope.org
> http://mail.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://mail.zope.org/mailman/listinfo/zope-announce
>  http://mail.zope.org/mailman/listinfo/zope-dev )
>   
try to switch off LIMIT 1000 (in the properties of ZSQLAdapter)

robert
-------------- next part --------------
A non-text attachment was scrubbed...
Name: robert.vcf
Type: text/x-vcard
Size: 200 bytes
Desc: not available
Url : http://mail.zope.org/pipermail/zope/attachments/20060501/bd591871/robert.vcf