[Zope] Multiple SQL statements in a single ZSQL method?

Harlow Pinson hpinson@indepthl.com
Wed, 19 Dec 2001 12:48:00 -0700


Thanks Phil!  That did the trick.   Just to sum it up for others.

To add multiple sql statements to a ZSQL method calling a Microsoft 
Access database via the MS ODBC driver:

1.  Create a ZSQL Method.
2.  Configure the multi-select statement, for example, like this:

INSERT INTO tblUsers (user_id) VALUES (<dtml-sqlvar user_id 
type=nb>);
<dtml-var sql_delimiter>
INSERT INTO tblParents (user_id) VALUES (<dtml-sqlvar user_id 
type=nb>);
<dtml-var sql_delimiter>
INSERT INTO tblChildren (user_id) VALUES (<dtml-sqlvar user_id 
type=nb>);
<dtml-var sql_delimiter>

Harlow Pinson
Indepth Learning
Email: hpinson@indepthl.com 
Web: http://www.indepthl.com
Voice: 505-994-2135
FAX: 208-475-7678