Whats your entire SQL and what is your database. Normally in SQL ' is a reserved character so use <dtml-sqlvar > to quote your string and avoid this problem. See the ZSQLMethod docs for more on dtml-sqlvar. -- Andy McKay ----- Original Message ----- From: "Gitte Wange" <gitte@mmmanager.org> To: <zope@zope.org> Sent: Thursday, April 05, 2001 3:50 AM Subject: [Zope] Weird error

Hello, I get this error that I cannot find out to solve: Error Type: error Error Value: You have an error in your SQL syntax near '['2', '2']' at line 1

Okay I can see what is going on. I have this little form with a select box in and when you hit the submit button a ZSQL methos is called with the value of the selct box as an argument. Yes I have checked that I have typed the name right.

SO anyone have any idea of why I get this error?

Regards, -- ************************ Gitte Wange Jensen

System Squid Developer MMManager Aps +45 29 72 79 72

gitte@mmmanager.org ************************

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

You need to find out the exact string of the sql statement that is getting sent to the database and paste that into another post. Otherwise it's be darned hard to say anything useful. Just offhand, '2','2' doesn't look like valid sql. Gitte Wange asks -

I get this error that I cannot find out to solve: Error Type: error Error Value: You have an error in your SQL syntax near '['2', '2']' at line 1

Okay I can see what is going on. I have this little form with a select box in and when you hit the submit button a ZSQL methos is called with the value of the selct box as an argument. Yes I have checked that I have typed the name right.

Cheers, Tom P