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 )