RE: CFMX 6.1 and MySQL insert question
> If a user is using the form and enter the value "bla bla \n > bla bla \bla.." > because he wants the \n or the \ it won't work.. I don't want > to used the \n as a break like with #Chr(13)##Chr(10)# Use - it'll correctly escape everything for you so you don't have to worry about the "\n" being changed to a newline char when inserted. Tim. -- --- Badpen Tech - CF and web-tech: http://tech.badpen.com/ --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 and MySQL insert question
I mean, If a user is using the form and enter the value "bla bla \n bla bla \bla.." because he wants the \n or the \ it won't work.. I don't want to used the \n as a break like with #Chr(13)##Chr(10)# Patrick _ From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: July 21, 2004 22:41 To: CF-Talk Subject: RE: CFMX 6.1 and MySQL insert question I don't follow you... > Thanks but that won't work cause I don't know where someone > is wirting \n\n in the textbox.. _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 and MySQL insert question
I don't follow you... > Thanks but that won't work cause I don't know where someone > is wirting \n\n in the textbox.. [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 and MySQL insert question
Thanks but that won't work cause I don't know where someone is wirting \n\n in the textbox.. Patrick _ From: Michael T. Tangorre [mailto:[EMAIL PROTECTED] Sent: July 21, 2004 22:33 To: CF-Talk Subject: RE: CFMX 6.1 and MySQL insert question You want to use this instead: #Chr(13)##Chr(11)# Mike > Hi, I'm trying to insert this > "Error\n\nYou must provide a password to enter" > In a MySQL database through a CFMX 6.1 cfquery and the \n\n > are replace by spaces in the databases... what could I do? _ [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 and MySQL insert question
Correction.. #Chr(13)##Chr(10)# It is 10 not 11. :-) Mike > You want to use this instead: > #Chr(13)##Chr(11)# > > Hi, I'm trying to insert this > > "Error\n\nYou must provide a password to enter" > > In a MySQL database through a CFMX 6.1 cfquery and the \n\n are > > replace by spaces in the databases... what could I do? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
RE: CFMX 6.1 and MySQL insert question
You want to use this instead: #Chr(13)##Chr(11)# Mike > Hi, I'm trying to insert this > "Error\n\nYou must provide a password to enter" > In a MySQL database through a CFMX 6.1 cfquery and the \n\n > are replace by spaces in the databases... what could I do? [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
CFMX 6.1 and MySQL insert question
Hi, I'm trying to insert this "Error\n\nYou must provide a password to enter" In a MySQL database through a CFMX 6.1 cfquery and the \n\n are replace by spaces in the databases... what could I do? Thanks PAtrick [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]