[Zope] LAST INSERT ID driving me crazy

[Infor Gates]

I don't think Zope provide the said  feature.

1.  I use ZopeTime (e.g. datetime_id.) as the last_insert_query id.  You can use python date time too.
2.  All related database tables have a datetime_id column
3.  Using zsql method:
     insert into table_name
    set t_datetime_id=<dtml-sqlvar datetime_id type="string">,
    ........

Good Luck

CY

Alric Aneron <aluminum3458 at yahoo.com> 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 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 )


		
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.zope.org/pipermail/zope/attachments/20060501/f279be42/attachment.htm