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 cfqueryparam - it'll correctly escape everything for you so you don't have to worry about the \n

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]

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

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

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

: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