parameterized query with wildcard

Dave Kilroy dave at
Tue Jul 28 12:07:46 EDT 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:
Sent from the Revolution - User mailing list archive at

More information about the Use-livecode mailing list