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
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
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
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
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
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
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
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
8 matches
Mail list logo