[Zope] ZSQL - multiple inserts to multiple tables in one query.

Dan Jacobs dan@danjacobs.com
Wed, 25 Sep 2002 01:21:11 +0100 (BST)


Hi All,

I am developing my first Zope/SQL application.

I'm not a coder by profession (more a sysadmin) so I may be missing
something.

I have a database which stores information on musical scores.  I am trying
to write a zope interface to add new musical scores.  My schema has
several tables and in each table 2/3 fields need values inserted into them
each time a new musical score is added.

So my question is...  How do I do this within one ZSQL method?

Thanks,

Dan