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

[Paulo Eduardo Neves]

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