ZSQLMethod sqltest with like and %
19 Jul
2001
19 Jul
'01
2:09 p.m.
Hi I had trouble with getting this: select * from qryPerson where Surname like '%urnet%' (where I had given urnet as the search text.) The following works, and as I couldn't find a solution in the docs or mailing list, I thought I'd post it here for others as dumb as me to see:-) <dtml-let Surname="'%' + Surname + '%'"> select * from qryPerson where <dtml-sqltest Surname op=like type=string> </dtml-let> Mind you, I can't help thinking that the op=eq should be clever enough to use 'like' when a string contains wildcards. Regards Neil PS Note for database gurus: Yes, I know that searching with a wild card in front negates my column index.
9028
Age (days ago)
9028
Last active (days ago)
0 comments
1 participants
participants (1)
-
Neil Burnett