Replace quotes with other character

Louisa · April 19th, 2005, 04:44 AM

I have a memo field where the user enters text and this then updates the database, this works fine until the user enters a quote and of course the SQL query then fails. How can I remove all quotes and replace them with a different character?

Thanks
Louisa

r_ganesh76 · April 19th, 2005, 06:04 AM

How do you do the update?? are you using the SqlCommand or OleDBCommand to do the update. If you use that you can eliminate the problem

Regards
Ganesh

r_ganesh76 · April 19th, 2005, 06:05 AM

Please reply if you need furthur help

Regards
Ganesh

planoie · April 19th, 2005, 07:55 AM

Quote:

quote:Originally posted by r_ganesh76
are you using the SqlCommand or OleDBCommand to do the update. If you use that you can eliminate the problem

Not entirely true: If you use Parameters in the Command objects then you don't have to worry about quote escaping. Just using a Command object alone isn't enough. You have to use it correctly.

Louisa,
It's just a matter of replacing ' with '' in your command text.

-Peter

Louisa · April 19th, 2005, 08:10 AM

I do use SQL to update the database, but how can I replace the ' ' with ""?

Thanks Louisa

planoie · April 19th, 2005, 08:21 AM

A SQL query should only care about the single quote.

memoFieldValue.Replace("'", "''")

Louisa · April 19th, 2005, 08:38 AM

Perfect thanks very much

Louisa

r_ganesh76 · April 19th, 2005, 11:08 PM

Sorry I missed out that.

Quote:

quote:Originally posted by planoie

Quote:

quote:Originally posted by r_ganesh76

Quote:

are you using the SqlCommand or OleDBCommand to do the update. If you use that you can eliminate the problem

Not entirely true: If you use Parameters in the Command objects then you don't have to worry about quote escaping. Just using a Command object alone isn't enough. You have to use it correctly.

Louisa,
It's just a matter of replacing ' with '' in your command text.

-Peter

Regards
Ganesh