I thought preservesinglequotes() prevents coldfusion from automatically escaping single quotes... try it without:) ----- Original Message ----- From: "Snake Hollywood" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, September 26, 2003 10:33 AM 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]
