21:51
To: CF-Talk
Subject: Re: RE: FW: RE: Quotation Hell
Thank you James.
It still amazes me that loads of people don't use HTMLEditFormat().
Nothing like seeing lots of pages break simply because of people
entering quotes.
- Original Message -
From: James Ang [EMAIL PROTECTED]
Date
I have a form which the user gets to fill in, they put into a input
type=text...
A quote: To be or not to be
now in my insert statement I have...
INSERT INTO sometable (somecol)
VALUES ('#htmlEditFormat(form.field)#')
which translates to..
INSERT INTO sometable (somecol)
VALUES ('A
Cheers, I thought I might be doing it wrong, but what about using the Left()
function on your output, I don't see a way around this?
Ade
-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2002 11:40
To: CF-Talk
Subject: Re: RE: FW: RE: Quotation Hell
I
Actually I do, I was nesting them the wrong way :OS
Ade
-Original Message-
From: Adrian Lynch [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2002 11:50
To: CF-Talk
Subject: RE: RE: FW: RE: Quotation Hell
Cheers, I thought I might be doing it wrong, but what about using the Left()
function
Hell
Cheers, I thought I might be doing it wrong, but what about using the
Left()
function on your output, I don't see a way around this?
Ade
-Original Message-
From: Justin Scott [mailto:[EMAIL PROTECTED]]
Sent: 14 June 2002 11:40
To: CF-Talk
Subject: Re: RE: FW: RE: Quotation
instance
of the quotesquotes
- Original Message -
From: Adrian Lynch [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 14, 2002 6:24 AM
Subject: RE: RE: FW: RE: Quotation Hell
Sorry for bringing this back up, but I don't think you've understood one
of
the points I
Check the docs for #preserveSingleQuotes()#.
This will help you avoid problems with quotes in SQL statements.
Eric
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 8:59 AM
To: CF-Talk
Subject: Quotation Hell
Hi Folks,
A problem has
I've yet to see a fool proof way of doing this, depending on how much you
care about the form, you could compensate for one quote over the other. If
you know that the value will only ever contain a double quote, use single
quotes in the html, value='whatever', or visa versa.
If you're not sure
try using the function: htmleditformat or function : preservesinglequotes
- Original Message -
From: Deanna Schneider [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 8:59 AM
Subject: Quotation Hell
Hi Folks,
A problem has just cropped up that I've never
Yep. That makes sense. I wonder why in two years I've never come across this
as a problem before. Ugh.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
__
Signup for the Fusion Authority news alert and keep
]]
Sent: 13 June 2002 14:23
To: CF-Talk
Subject: Re: Quotation Hell
Yep. That makes sense. I wonder why in two years I've never come across this
as a problem before. Ugh.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED
This happens to the best of us.
The only simple options I know of are to either use a textarea if allowing quotes is
that important, or just strip out double quotes, perhaps replacing them with nothing
or single quotes.
Charlie [EMAIL PROTECTED] 06/13/02 09:18AM
try using the function:
Contrary to the other people on the list who believe this is a hard problem
to fix, it is not.
Use HTMLEDITFORMAT.
Like, does no one actually read documentation anymore?
-Original Message-
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 6:59 AM
To:
June 2002 15:57
To: CF-Talk
Subject: RE: Quotation Hell
Contrary to the other people on the list who believe this is a hard problem
to fix, it is not.
Use HTMLEDITFORMAT.
Like, does no one actually read documentation anymore?
-Original Message-
From: Deanna Schneider [mailto:[EMAIL
'there is alot to learn out there and not always the time'
the function htmleditformat work successfully on our pages
- Original Message -
From: Kwang Suh [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, June 13, 2002 10:56 AM
Subject: RE: Quotation Hell
Contrary
-Original Message-
From: Adrian Lynch
Sent: 13 June 2002 17:33
To: '[EMAIL PROTECTED]'
Subject: RE: RE: Quotation Hell
Thats ok, you can be a jackarse all you want. I hadn't used htmlEditFormat()
before, if I had, I might have suggested it. It was a case of I've got a way
around
Have a look at my other points though, the converted string can still be
messed about with
-Original Message-
From: Charlie [mailto:[EMAIL PROTECTED]]
Sent: 13 June 2002 18:29
To: CF-Talk
Subject: Re: Quotation Hell
'there is alot to learn out there and not always the time
).
~Todd
On Thu, 13 Jun 2002, Adrian Lynch wrote:
-Original Message-
From: Adrian Lynch
Sent: 13 June 2002 17:33
To: '[EMAIL PROTECTED]'
Subject: RE: RE: Quotation Hell
Thats ok, you can be a jackarse all you want. I hadn't used htmlEditFormat()
before, if I had, I might have
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 10:48 AM
To: CF-Talk
Subject: Re: FW: RE: Quotation Hell
Just jumping in briefly to explain what I did to get around and ' in
our
apps. Going into the database would be fine (using
perserveSingleQuotes
. :)
James Ang
Senior Programmer
MedSeek, Inc.
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 13, 2002 10:48 AM
To: CF-Talk
Subject: Re: FW: RE: Quotation Hell
Just jumping in briefly to explain what I did to get
One thing you might notice with htmlEditFormat(), is that you still have
the
problem of extra characters, still becomes quot;, and if that's what
you
put in you DB and you then use Left(), you have a problem if it chops it,
and you still need to make sure your DB is not going to be expecting
21 matches
Mail list logo