[vox-tech] MySQL + Zope

[David Siedband]

Hello all,

I'm trying to do an SQL insert from within Zope that makes entries in 
two separate tables.  The data entity is a calendar event and most of 
it's fields go in an events table, except the event date.  The event 
date gets stored only in an index table that is linked by an event id.  
The tricky part is to get the event ID (eid) that is auto-incremented 
by MySQL from the first query and pass it to the second insert 
statement.


Here's what the code looks like.  The '?????' is the piece I'm trying 
to figure out

++++++++++++++++++++++++++++++++++++++++

insert into `Events` ( `eid` , `oid` , `gcid` , `startTime` , `endTime` 
, `title` , `description` , `public` , `free` , `location` )
values (
'', '<dtml-var oid>', '<dtml-var gcid>', '<dtml-var 
startTimeHH>:<dtml-var startTimeMM>:00', '<dtml-var 
endTimeHH>:<dtml-var endTimeMM>:00', '<dtml-var evTitle>', '<dtml-var 
descriptor>', '<dtml-var public>', '<dtml-var free>', '<dtml-var 
location>'
);

insert into `EvDates` ( `edid` , `eid` , `edate`)
values ('', '?????', '<dtml-var mm>-<dtml-var dd>-<dtml-var yyyy>');

+++++++++++++++++++++++++++++++++++++++++


--
David