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