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

Oliver Andrich wrote:

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

You are probably using <dtml-sqlvar foobarVar type=string>. Try to use <dtml-var foobarVar> to get it without the '. If it doesn't work try to post your ZSQL method code. []s -- Paulo Eduardo Neves maito:neves@email.com