Re: [Zope] Problem Inserting zsql query result

Ivan Stout wrote:

Yes, the full error message is the following:

" ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0\n)' at line 9") "

Here is the select portion of the query I am running:

select count(*) as "order"

I'd look for the bit of your SQL that is '0' at the end of a line ;-) What's your full ZSQL? (well, actually, boil it down to a minimal test case that fails...) cheers, Chris -- Simplistix - Content Management, Zope & Python Consulting - http://www.simplistix.co.uk