parameterized query with wildcard

Dave Kilroy dave at applicationinsight.com
Tue Jul 28 18:07:46 CEST 2015


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.



More information about the use-livecode mailing list