PreserveSingleQuotes() specifically does not escape single quotes, that's it's job.
Example... ? > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 26 September 2003 10:34 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX and single quotes > > > It's access. > And preservesinglequotes always used to escape them fine. Has this > broken in CFMX ? > And yes I am am only just getting around to porting code over to CFMX. > > > > -----Original Message----- > > From: Stephen Pope [mailto:[EMAIL PROTECTED] > > Sent: 26 September 2003 09:54 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] CFMX and single quotes > > > > > > Also .. what DB is it ? :�) > > > > -----Original Message----- > > From: Steve Martin [mailto:[EMAIL PROTECTED] > > Sent: 26 September 2003 09:53 > > To: [EMAIL PROTECTED] > > Subject: RE: [ cf-dev ] CFMX and single quotes > > > > You need to escape single quotes. Show us yer code. > > > > > -----Original Message----- > > > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > > > Sent: 26 September 2003 09:46 > > > To: [EMAIL PROTECTED] > > > Subject: [ cf-dev ] CFMX and single quotes > > > > > > > > > Just uploaded a site onto CFMX, works fine even though it > > was done on > > > CF5. But database inserts where a single quote ' is in the text > > > fails on CFMX > > > with a meaningless DB error, using preservesinglequotes and > > > all that has > > > made no difference. > > > What's the hooky reason for this then ? > > > > > > > > > > > > -- > > > ** Archive: > > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > > > > To unsubscribe, e-mail: > > [EMAIL PROTECTED] > > > For additional commands, e-mail: > > [EMAIL PROTECTED] For > > > human help, e-mail: [EMAIL PROTECTED] > > > > > > > > > > -- > > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] For human help, e-mail: > [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
