[Zope] Weird error

Zopista zopista@zopezen.org
Thu, 5 Apr 2001 06:07:07 -0700


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