replacing apostrophes in text box

[shank]

I replace apostrophes in usual small text strings.
How can I keep them when submitting a text box with a 500 character limit?
Am I forced to just replace them?

thanks

 

[Steven Burn]

string = request.form("The_Text_Box")
Server.URLEncode(string)

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Personal favourites

Practically Nerded - http://mvps.org/PracticallyNerded/
Bugs, Glitches n stuff - http://mvps.org/inetexplorer/Darnit.htm
Calendar of Updates - http://www.dozleng.com/updates/index.php?&act=calendar

 

[Ray at]

Why is it any different with 500 characters? Are you running into some sort
of a problem? If so, can you describe it?

Ray at work

 

[shank]

The basis of the question was "how to keep the apostrophes from a text
box"...
thanks

 

[Aaron Bertrand [MVP]]

If you don't want the user to enter apostrophes, then use client-side script
to validate (either as they are typing, or when they hit submit).

However, I think this is a silly limitation. Consider keeping the
apostrophes in the data, since you can work around the problem that
apostrophes mess up SQL statements, without making the users pay for it by
using the back-apostrophe (`) or going without just because you didn't feel
like handling it properly.

http://www.aspfaq.com/2035

 

[Ray at]

I don't understand. How to deal with apostrophes when inserting into a
database? How to deal with them when doing a <input
value="<%=yourValue%>">? What?

Ray at work

 

[Vilmar]

YOU CAN do these on insert, update, select, delete:
varX = request("txtX")
varX = replace(varX,"'","''")

to show to user do this:
varX = objRs("FieldX")
varX = replace(varX,"''","'")

 

[Ray at]

You don't have to do any replacing like that on the way out, because the ''
isn't ever inserted (unless that was the original input value).

Ray at work

 

[Steven Burn]

In addition to Ray's comments, according to:
http://www.aspfaq.com/show.asp?id=2111 , it is not a good idea to use
request("item") ;o)

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Personal favourites

Practically Nerded - http://mvps.org/PracticallyNerded/
Bugs, Glitches n stuff - http://mvps.org/inetexplorer/Darnit.htm
Calendar of Updates - http://www.dozleng.com/updates/index.php?&act=calendar