RE: Special Characters driving me nuts

2003-03-10 Thread James Alexander
URLencode/decode are for passing data via URL. Are you doing this? Doug >-Original Message- >From: Joshua Miller [mailto:[EMAIL PROTECTED] >Sent: Monday, March 10, 2003 4:53 PM >To: CF-Talk >Subject: RE: Special Characters driving me nuts > > >I HAVE to use

RE: Special Characters driving me nuts

2003-03-10 Thread Douglas.Knudsen
URLencode/decode are for passing data via URL. Are you doing this? Doug >-Original Message- >From: Joshua Miller [mailto:[EMAIL PROTECTED] >Sent: Monday, March 10, 2003 4:53 PM >To: CF-Talk >Subject: RE: Special Characters driving me nuts > > >I HAVE to use

Re: Special Characters driving me nuts

2003-03-10 Thread Dina Hess
Oops...didn't see this before I posted. ~Dina - Original Message - From: "Joshua Miller" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 10, 2003 3:52 PM Subject: RE: Special Characters driving me nuts > I HAVE t

Re: RE: Special Characters driving me nuts

2003-03-10 Thread ksuh
AIL PROTECTED]> Date: Monday, March 10, 2003 2:52 pm Subject: RE: Special Characters driving me nuts > I HAVE to use URLEncodedFormat to store the data. Unfortunately > what I > have to do is allow a preview of the user's submission, but there are > around 50 fields I have to store

Re: Special Characters driving me nuts

2003-03-10 Thread Dina Hess
Joshua, All will be well if you send your form data directly to the DB in a CFQUERYPARAM tag ***without applying any functions***. That's especially important if you're using MX because there's an "apostrophe" bug that only occurs when Trim() is applied to parameter values inserted into or updatin

RE: Special Characters driving me nuts

2003-03-10 Thread Joshua Miller
EMAIL PROTECTED] Sent: Monday, March 10, 2003 2:41 PM To: CF-Talk Subject: Re: Special Characters driving me nuts Don't use URLEncodedFormat() when inserting the data. Place it into the database "as-is". Use HTMLEditFormat() to display the data. You'll have to update ro

Re: Special Characters driving me nuts

2003-03-10 Thread ksuh
Don't use URLEncodedFormat() when inserting the data. Place it into the database "as-is". Use HTMLEditFormat() to display the data. You'll have to update rows that you URLEncodedFormat() back to their original format. - Original Message - From: Joshua Miller <[EMAIL PROTECTED]> Date: M

RE: Special Characters driving me nuts

2003-03-10 Thread Douglas.Knudsen
common PITA... I usually do a Replace(stringname, '"', """) and a Replace(string, "'", "&rsquo") assuming the " and ' are stored in the DB as " and ' respectively. Note for dumping data like this into JavaScript, escape them. Doug >-Original Message- >From: Joshua Miller [mailto:[EMAIL