[Zope] help on ZMySQL

David Wagle david.a.wagle@healthpartners.com
Wed, 10 Mar 1999 10:56:41 -0600 (CST)


Zope 1.10.2

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 ';'.

I remove teh ';' and Zope tells me that 
"This was not a query."

I'm missing something, and I'm hoping it's not my 
mind . . . any help?

(oh, nad yes, the query works just fine when entered
by hand in a mysql or xmysql connection)


---------------------------------------------
A computer without Microsoft products is like
a dog without bricks chained to its head
---------------------------------------------