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

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'%"