I don't think Zope provide the said feature.<br><br>1. I use ZopeTime (e.g. datetime_id.) as the last_insert_query id. You can use python date time too.<br>2. All related database tables have a datetime_id column<br>3. Using zsql method:<br> insert into table_name<br> set t_datetime_id=<dtml-sqlvar datetime_id type="string">,<br> ........<br><br>Good Luck<br><br>CY<br><br><b><i>Alric Aneron <aluminum3458@yahoo.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> Hi guys,<br> HOW HOW HOW HOW!!!<br> Do I get at the last_insert_id() function, this is driving me absolutely crazy!!<br> 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!<br> <br> I would like to make a separate ZSQL Method that will return to me the last insert id.<br> <br> Any help would be appreciated.<br> <br> Thank you.<br> <div> </div><hr size="1">Yahoo! Messenger with Voice. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make PC-to-Phone Calls</a> to the US (and 30+ countries) for 2�/min or less._______________________________________________<br>Zope maillist - Zope@zope.org<br>http://mail.zope.org/mailman/listinfo/zope<br>** No cross posts or HTML encoding! **<br>(Related lists - <br> http://mail.zope.org/mailman/listinfo/zope-announce<br> http://mail.zope.org/mailman/listinfo/zope-dev )<br></blockquote><br><p>
<hr size=1>Yahoo! Messenger with Voice. <a href="http://us.rd.yahoo.com/mail_us/taglines/postman1/*http://us.rd.yahoo.com/evt=39663/*http://voice.yahoo.com">Make PC-to-Phone Calls</a> to the US (and 30+ countries) for 2¢/min or less.