ASP Comments field problem 1

[JrClown]

Hello all, I have an ASP page that produces an error everytime all users type an apostrophe in the "COMMENTS" field.
Examples:
I'm going to Florida = Will not work
I am going to Florida = Will work just fine

Everytime an apostrophe is entered my ASP page thinks it's part of the script. I thank you in advance.

QUOTE OF THE DAY
Everyone you meet knows something you don't know. Be willing to learn from them.

Jr_Clown )

 

[ukwebsite]

This will solve your apostrophe nightmare.

What ever variable you send to the SQL statment. Make sure you pass it through this line:

YOURVariable = replace(YOURVariable,"'","''&quot

It will replace the apostrophe with a double. Any problems email me with a snippit of your code and I will give you a hand.

Cheers
Matthew Wilde
matthew@ukwebsite.com

 

[Microbe]

ice simple fix. I had this problem and fixed it with an
inSTR statement and then parseing out the ' - but this is far more simple.

In fact, my company name has an apostrophe in it and it causes scripts to break on my bank's website. I offered to fix it for them (at a ridiculous price ) but they haven't gotten back to me.

Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[silvers5]

don't forget to get it back to single on the output! Silvers5 aka El-pirate
As seen on

http://www.Experts-exchange.com