Has anybody built any queries that use both parameters and wildcards, e.g. in a LIKE statement?
SELECT * FROM foo WHERE bar LIKE %:1% I've tried the above (error), I've tried '%':1'%' (error), and I've tried appending the % to the container I'm passing as my :1 (doesn't work). I really don't want to do this the unsafe way. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
