kray at sonsothunder.com
Wed Aug 22 16:36:14 CDT 2007
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.
Sons of Thunder Software, Inc.
Email: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/
More information about the use-livecode