[Zope] Multiple queries in a ZSQL method?

2000-10-22 Thread Noah
Hi, I'm using MySQL. I need to have a ZSQL Method that does an insert and a select in one call. After I do an insert I need to check the LAST_INSERT_ID to get the primary key of the record that I just inserted. Something like this: insert into author (id, name, sort_name, email, bio,

Re: [Zope] Multiple queries in a ZSQL method?

2000-10-22 Thread Ender
multiple non-select statements (max 1 select) are done through the use of dtml-var sql_delimiter kapil Noah wrote: Hi, I'm using MySQL. I need to have a ZSQL Method that does an insert and a select in one call. After I do an insert I need to check the LAST_INSERT_ID to get the primary

Re: [Zope] Multiple queries in a ZSQL method?

2000-10-22 Thread Phil Harris
select LAST_INSERT_ID() hth Phil [EMAIL PROTECTED] - Original Message - From: "Noah" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 22, 2000 9:29 PM Subject: [Zope] Multiple queries in a ZSQL method? | Hi, | | I'm using MySQL. I need to have a ZSQL Method