In SQLite, the way to escape an apostrophe is to precede it with another apostrophe, not a backslash. mySQL allows either method, not sure about other SQL implementations. Pete Molly's Revenge <http://www.mollysrevenge.com>
On Mon, Oct 3, 2011 at 10:40 AM, Pierre Sahores <s...@sahores-conseil.com>wrote: > > Le 3 oct. 2011 à 18:42, Bob Sneidar a écrit : > > > How are you escaping your sql? > > If not, it needed where "it's needed" becomes "it\'s needed" to be stored > in your SQL backend. > > _______________________________________________ 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