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

Philipp Auersperg phil@bluedynamics.com
19 Dec 2001 10:55:40 +0100


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 )
>