How can I take Quotation marks ( " ' ) out of a variable before I post it to a database.
The database return errors if I dont take it out.
ThanksUse the SqlParameter of OleDbParameter classes, and the database will not 'give errors'.
A single quote must be replaced by 2x single quote, when used in a query. This is the cause of the errors.
Check this post...
http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=317174
good luck sir
Thanks that helped a lot
u can use..
dim str as string
str = Replace(the_text, " ' ", "**")
0 comments:
Post a Comment