huh? whatchoo talking bout willis? Of course CFMX escapes single quotes. You'd think the whole CF developer world would have discovered something like that by now!
I've got a million apps (slight exaggeration) accepting text with single quotes and inserting them into SQL server just fine. It must be something else wrong. have you got an example? > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 26 September 2003 10:57 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX and single quotes > > > Well it wasn't using it in the first place when it broke. CF5 escapes > them, cfmx doesn't I guess. How annoying. > > > > -----Original Message----- > > From: Tom Smith [mailto:[EMAIL PROTECTED] > > Sent: 26 September 2003 10:36 > > To: [EMAIL PROTECTED] > > Subject: Re: [ cf-dev ] CFMX and single quotes > > > > > > 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] > > -- ** 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]
