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 ************************
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 )
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?
It would help if you would send us the SQLMethod and an excerpt of the code which is causing this problem; Andrew
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
participants (4)
-
Andrew Williams -
Gitte Wange -
Thomas B. Passin -
Zopista