On Feb 16, 2006, at 4:53 AM, David Burgun wrote:
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString
& "%'" into tSQL
David,
One addition to the above code. You will want to escape the search
string in case someone enters a character like "'". So change it to:
put libdb_escape("mysql", tSearchString) into tSearchString
put "SELECT * FROM myobjects WHERE Name LIKE '%" & tSearchString &
"%'" into tSQL
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
