you have to separate them with: <dtml-var sql_delimiter> phil Am Die, 2001-12-18 um 17.43 schrieb Harlow Pinson:
Just place ; at the end of sql statement.
When I do that, I get an ODBC error:
Error Type: sql.error Error Value: ('37000', -3517, '[Microsoft][ODBC Microsoft Access Driver] Characters found after end of SQL statement.')
Here's my very simple SQL statement, in the ZSQL method:
INSERT INTO tblUsers VALUES ( 5 );
INSERT INTO tblParents VALUES ( 5 );
The first statement by itself works fine.
Harlow Pinson Indepth Learning Email: hpinson@indepthl.com Web: http://www.indepthl.com Voice: 505-994-2135 FAX: 208-475-7678
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )