Thursday, March 22, 2012

Taking out Quotation marks in text.

Hi

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