[Zope] Zope SQL Method

rgines@purina.com rgines@purina.com
Mon, 28 Feb 2000 13:37:54 -0600


>I'm trying to use the Z SQL Method to create a table. I have the following
>code in that:

<snip>

>When I push the Submit Query button, it gives me a error: "Syntax Error".

>Where could that syntax error be? I already looked to the code and I fine
>him right, so I can't figure where the error could be.

>Can anyone help me on this?

Check to see if it was created properly.   I ran into this with the DB
setup I
was using.   My tables were always created fine.   If you look at the code
you will find that you will get a synyax error on just about anything that
is not a
SELECT statement.   The string is passed fine however.

THis is what happened to me.   You milage may vary ....