On Wed, 22 Aug 2007 12:50:33 -0700, Robert Sneidar wrote: > Hi All. > > I am having an issue that I know was addressed in a previous post but > I cannot seem to find it. I have established some functions to work > with mySQL databases, and all is working fine except that whenever I > build an SQL statement with values that include commas, carriage > returns and the like, it hoses the sql statement. Isn't there a way > of delimiting reserved characters in an sql statement? Something like > preceding them with a backslash?
Yes, but only for certain chars that would cause problems in queries like a single quote. If you have carriage returns, you'll have to replace the CRs with some other character for storage, and then convert them back when you retrieve the data. Ken Ray Sons of Thunder Software, Inc. Email: [EMAIL PROTECTED] Web Site: http://www.sonsothunder.com/ _______________________________________________ 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
