l i n u x - u s e r s - g r o u p - o f - d a v i s
L U G O D
 
Next Meeting:
August 18: A professional photographer's view of Linux
Next Installfest:
TBD
Latest News:
Aug. 18: Discounts to "Velocity" in NY; come to tonight's "Photography" talk
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>');

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


--
David

_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech



LinkedIn
LUGOD Group on LinkedIn
Sign up for LUGOD event announcements
Your email address:
facebook
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:
O'Reilly and Associates
For numerous book donations.