text box question...

[Rino5555]

Hi to all...

I have a few text box's on my site and i would like to know how can i replace if a user enters a single quote ' and re-place it with nothing...

The problem i'm having is when a user enters a single quote i get an error on the page because this info gets inputed into a database...

Hope someone can help me...

Rino

[EnterpriseArchitect]

You can take that textbox form object and run a Replace against it:

<code>
Dim strTextboxReplace
strTextBoxReplace - Request.Form("textbox_name_here")


'below, the data in the text box is going to be looked at and the
'single quotes will be replaced with nothing
strTextBoxReplace = Replace(textbox_name_here, "'", "")
</code>

---------- or better yet, if single quotes are needed, you could replace them with the ASCII value that will present the single quote in the HTML but not blow up any data access:

'below, the data in the text box is going to be looked at and the
'single quotes will be replaced with the ASCII value for a single quote:

strTextBoxReplace = Replace(textbox_name_here, "'", "&#39;")

[Rino5555]

where would put this right after my textbox code

[myrs2]

where we can buy cheap runescape gold
follow me,click here and buy cheap runescape equipment
runescape accounts
runescape accounts
cheap runescape gold
cheap runescape gold
cheap runescape items
cheap runescape gold
buy runescape items
runescape gold
runescape items
runescape powerleveling
runescape equipment
buy runescape accuonuts
buy runescape item
buy runescape gold
runescape equipments
runescape powerleveling
runescape item
cheap runescape accounts
runescape items
cheap ruenscape account
cheap runescape equipments
buy runescape account
runescape item
cheap runescape power leveling
runescape equipments
cheap rs2 accounts
rs2 equipments
runescape guides
buy runescape equipment
cheap runescape power leveling
rs2 items
cheap runescape gold
runescape equipment
rs2 powerleveling
rs item
buy runescape moeny
cheap rs equipments
runescape equipments
buy runescape moeny
cheap rs gold
rs equipments
runescape equipment
buy runescape equipments
cheap runescape power leveling
buy rs2 items
runescape items
cheap rs2 powerleveling
cheap runescape items
rs items
runescape item
cheap rs items
buy runescape item
buy runescape gold
runescape2 items
cheap runescape2 items
runescape items
cheap rs2 gold
runescape2 equipments
runescape powerleveling
runescape equipments
cheap runecape gold
cheap rs items
cheap rs gold
buy runescape items
buy rs2 items
cheap runescape accounts
runescape powerleveling
cheap runecape equipments
cheap runescape power leveling
cheap rs2 power leveling
runescape account

Runescape items,equipment,powerleveling,accounts Selling, We sell Runescape 2 Gold, RuneScape Money, RuneScape GP, 24/7 online support and Fast Delivery.