[Zope] Multi-statement ZSQL Methods

Jeremy Fitzhardinge jeremy@goop.org
Mon, 16 Aug 1999 15:09:29 -0700 (PDT)


On 16-Aug-99 Martijn Pieters wrote:
> Use <!--#var sql-delimiter--> instead:
> 
> insert users (name, email, type) values('foo', 'bar@biff.org', 'normal')
> <!--#var sql-delimiter-->
> select user_id from users where user_id = LAST_INSERT_ID()

Thanks, that's exactly what I needed (though it's spelled 'sql_delimiter').

        J