(no subject)

[Ken Ray]

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: kray at sonsothunder.com
Web Site: http://www.sonsothunder.com/