[vox-tech] MySQL + Zope

[Jeff Newmiller]

On Wed, 14 May 2003, David Siedband wrote:

> 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.

http://www.mysql.com/doc/en/example-AUTO_INCREMENT.html

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...2k
---------------------------------------------------------------------------