[Zope] SQL queries with LIKE???? (Am I to dumb?)

Phillip J. Eby pje@telecommunity.com
Wed, 22 Sep 1999 14:37:17 -0500


Use <!--#var foobar sql_quote--> instead of <!--#sqlvar foobar-->.

At 08:55 PM 9/22/99 +0200, Oliver Andrich wrote:
>Hi,
>
>I like to create a SQL Method that does a query like
>
>select * 
>from account_info
>where account like "%foobar%"
>
>But I only get equality tests or a query that looks like that
>
>select *
>from account_info
>where account like "%'foobar'%"
>