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 (http://www.gprunescape22.com/runescape-equipment)
runescape accounts (http://www.gprunescape2.com/runescape-accounts.html)
runescape accounts (http://www.mmors2.com/index.html)
cheap runescape gold (http://www.myrs2.com/)
cheap runescape gold (http://www.gprunescape22.com/runescape-runes)
cheap runescape items (http://www.gprunescape2.com/runescape-equipment2.html)
cheap runescape gold (http://www.mmors2.com/)
buy runescape items (http://www.myrs2.com/index.html)
runescape gold (http://www.gprunescape22.com/runescape-logs)
runescape items (http://www.gprunescape2.com/runescape-equipment3.html)
runescape powerleveling (http://www.mmors2.com/runescape-powerleveling.html)
runescape equipment (http://www.myrs2.com/runescape-equipment.html)
buy runescape accuonuts (http://www.gprunescape22.com/index)
buy runescape item (http://www.gprunescape2.com/runescape-equipment4.html)
buy runescape gold (http://www.mmors2.com/Runescape-gold.html)
runescape equipments (http://www.myrs2.com/runescape-equipment2.html)
runescape powerleveling (http://www.gprunescape22.com/runescape-powerleveling)
runescape item (http://www.gprunescape2.com/runescape-equipment5.html)
cheap runescape accounts (http://www.mmors2.com/runescape-othergoods1.html)
runescape items (http://www.myrs2.com/runescape-equipment3.html)
cheap ruenscape account (http://www.gprunescape22.com/runescape-accounts)
cheap runescape equipments (http://www.gprunescape2.com/runescape-equipment6.html)
buy runescape account (http://www.mmors2.com/runescape-runes1.html)
runescape item (http://www.myrs2.com/runescape-equipment4.html)
cheap runescape power leveling (http://www.gprunescape22.com/runescape-news)
runescape equipments (http://www.gprunescape2.com/runescape-equipment7.html)
cheap rs2 accounts (http://www.mmors2.com/runescape-party-hat1.html)
rs2 equipments (http://www.myrs2.com/runescape-equipment5.html)
runescape guides (http://www.gprunescape22.com/runescape-guides)
buy runescape equipment (http://www.gprunescape2.com/runescape-equipment8.html)
cheap runescape power leveling (http://www.mmors2.com/runescape-bargain-sets1.html)
rs2 items (http://www.myrs2.com/runescape-equipment7.html)
cheap runescape gold (http://www.gprunescape22.com/runescape-gold)
runescape equipment (http://www.gprunescape2.com/runescape-equipment9.html)
rs2 powerleveling (http://www.mmors2.com/Aboutus.html)
rs item (http://www.myrs2.com/runescape-equipment8.html)
buy runescape moeny (http://www.gprunescape22.com/runescape-contactus)
cheap rs equipments (http://www.gprunescape2.com/runescape-equipment10.html)
runescape equipments (http://www.mmors2.com/runescape-equipment8.html)
buy runescape moeny (http://www.myrs2.com/runescape-Gold.html)
cheap rs gold (http://www.gprunescape22.com)
rs equipments (http://www.gprunescape2.com/runescape-equipment11.html)
runescape equipment (http://www.mmors2.com/runescape-equipment7.html)
buy runescape equipments (http://www.gprunescape22.com/runescape-equipment2)
cheap runescape power leveling (http://www.myrs2.com/Orderstep.html)
buy rs2 items (http://www.gprunescape2.com/runescape-equipment111.html)
runescape items (http://www.mmors2.com/runescape-equipment6.html)
cheap rs2 powerleveling (http://www.myrs2.com/services.html)
cheap runescape items (http://www.gprunescape22.com/runescape-equipment3)
rs items (http://www.gprunescape2.com/runescape-equipment.html)
runescape item (http://www.mmors2.com/runescape-equipment5.html)
cheap rs items (http://www.myrs2.com/aboutus.html)
buy runescape item (http://www.gprunescape22.com/runescape-equipment4)
buy runescape gold (http://www.gprunescape2.com/runescape-logs.html)
runescape2 items (http://www.mmors2.com/runescape-equipment4.html)
cheap runescape2 items (http://www.myrs2.com/runescape-logs.html)
runescape items (http://www.gprunescape22.com/runescape-equipment5)
cheap rs2 gold (http://www.gprunescape2.com/runescape-othergoods2.html)
runescape2 equipments (http://www.mmors2.com/runescape-equipment3.html)
runescape powerleveling (http://www.myrs2.com/runescape-powerleveling.html)
runescape equipments (http://www.gprunescape22.com/runescape-equipment6)
cheap runecape gold (http://www.gprunescape2.com/runescape-othergoods.html)
cheap rs items (http://www.mmors2.com/runescape-equipment2.html)
cheap rs gold (http://www.myrs2.com/runescape-othergoods.html)
buy runescape items (http://www.gprunescape2.com/runescape-party-hat.html)
buy rs2 items (http://www.mmors2.com/runescape-equipment1.html)
cheap runescape accounts (http://www.myrs2.com/runescape-runes.html)
runescape powerleveling (http://www.gprunescape2.com/runescape-powerleveling.html)
cheap runecape equipments (http://www.gprunescape2.com/runescape-runes.html)
cheap runescape power leveling (http://www.gprunescape2.com/services.html)
cheap rs2 power leveling (http://www.gprunescape2.com/western-union.html)
runescape account (http://www.gprunescape2.com/accounts/combat54.html)

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