22 Sep
1999
22 Sep
'99
8:34 p.m.
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