l i n u x - u s e r s - g r o u p - o f - d a v i s
Next Meeting:
July 7: Social gathering
Next Installfest:
Latest News:
Jun. 14: June LUGOD meeting cancelled
Page last updated:
2003 May 19 08:46

The following is an archive of a post made to our 'vox-tech mailing list' by one of its subscribers.

Report this post as spam:

(Enter your email address)
[vox-tech] MySQL + Zope
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[vox-tech] MySQL + Zope

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>');



vox-tech mailing list

LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
LUGOD Group on Facebook
'Like' LUGOD on Facebook:

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
PO Box 2082, Davis, CA 95617
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.

Sponsored in part by:
EDGE Tech Corp.
For donating some give-aways for our meetings.