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

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