parameterized query with wildcard

[Dave Kilroy]

Mike, assuming you are searching the db with parameter pSearchTerm, try
something like this:


put "%" & pSearchTerm & "%" into tSearchTerm
put "SELECT * FROM foo WHERE bar LIKE :1" into tQuery
get revDataFromQuery(tab, return, sDBID, tQuery, "tSearchTerm")






-----
"The difference between genius and stupidity is; genius has its limits." - Albert Einstein
--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/parameterized-query-with-wildcard-tp4694407p4694419.html
Sent from the Revolution - User mailing list archive at Nabble.com.