Well that is pretty much what my code does, except I don't use cfsavecontent. Must be an access thing then
------------------------------------------------------------------------ - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 26 September 2003 11:18 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] CFMX and single quotes The following works just fine for me with cfmx and sql 2000: (watch wrap) <cfscript> function convertText(inText) { var convertedText = ""; if (len(trim(inText))) { convertedText = replace(replace(inText, chr(10), "", "ALL"), chr(13), "<br />#chr(13)#", "ALL"); } return convertedText; } </cfscript> <cfsavecontent variable="textstr"> This is my content. Not Snake's content. But mine. I am having a lot of fun. </cfsavecontent> <cfset txttemp = convertText(textstr)> <cfquery name="test" datasource="#dsn#"> INSERT INTO test(textcol) VALUES('#txttemp#') </cfquery> > -----Original Message----- > From: Snake Hollywood [mailto:[EMAIL PROTECTED] > Sent: 26 September 2003 11:11 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] CFMX and single quotes > > > It's a simple insert. > > <cfset texttemp ="#textareaformat(form.description)#"> > > <CFQUERY datasource="#request.HelpdeskDSN#" > username="#request.helpdeskDBusername#" > password="#request.helpdeskDBpassword#"> > insert into ticketdata (taskID,trackID,created,name,details) > values( > #lastticket.taskID#,'#trackID#',#now()#,'#form.name#','#texttemp#') > </cfquery> > > TextareaFormat simply replaces CR and NEWLINE with <BR> > It is set outside the query because CF5 also balks on single quotes if > you use a function on a string inside the query itself. It seems to > not escape quotes if you perform any function on the string first. > > To make this work in CFMx I have strippe dout the quotes for now. > > > > -----Original Message----- > > From: Rich Wild [mailto:[EMAIL PROTECTED] > > Sent: 26 September 2003 11:00 > > To: '[EMAIL PROTECTED]' > > Subject: RE: [ cf-dev ] CFMX and single quotes > > > > > > 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] > > -- ** 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]
