From: David Wagle <david.a.wagle@healthpartners.com> I have a ZSQL method for inserting data into the database. The database connection is active. the permissions are correct. the method is defined roughly as:
insert into tblname (col1, col3, col4, col5) values (col1val, "value taht is constant", col4val, col5val);
when I try and test it, Zope tells me that there is a parse error near ';'.
If you're doing just a single query, you don't need the ';' (or its equivilent). If you're doing multiple queries, use <!--#var sql_delimiter--> to seperate them. The DA will seperate the queries using this. This is equivilent to what command line or other SQL tools often do with the ';' character.
I remove teh ';' and Zope tells me that "This was not a query."
Nothing is being returned is what this means (or more basically, it wasn't a SELECT based query). .jPS | jeffrey@digicool.com zope, through the web. www.zope.org