February 21st, 2004, 03:30 PM
|
 |
Contributing User
|
|
Join Date: Feb 2004
Posts: 72
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
|
Preparing strings for input into a database
Here is a very simple function you can use to prepare strings for being put into a database:
Code:
function fieldReplace(item2)
item2 = replace(item2, " ", " ")
item2 = replace(item2, "'", "'")
item2 = replace(item2, """", """)
item2 = replace(item2, "<", "&ls;")
item2 = replace(item2, ">", ">")
item2 = replace(item2, "%", "%")
item2 = replace(item2, vbcrlf, "<br>")
fieldReplace = item2
end function
Simply put that at the top of your script then call it on each variable:
Code:
var1 = fieldReplace(var1)
var2 = fieldReplace(var2)
And the reverse of this function:
Code:
function reverseReplace(item1)
item1 = replace(item1, " ", " ")
item1 = replace(item1, "<br>", vbcrlf)
item1 = replace(item1, "'", "'")
item1 = replace(item1, """, """")
item1 = replace(item1, "&ls;", "<")
item1 = replace(item1, ">", ">")
item1 = replace(item1, "%", "%")
reverseReplace = item1
end function
Use this in the same way!
__________________
If in doubt, google it!
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
