Inserting a string containing single quote

[gomzi]

hi,
I am trying to insert a string which contains a single quote into the database.

i.e. something like -> windows'xp'

using this query

str=windows'xp'

cmd1.CommandText = "insert into table_a values(" & str & ");"

i even tried replacing ' by \' But that too didnt work.

any help would be appreciated.
thanks,
gomzi.

[mklprasanna]

hi,
I am trying to insert a string which contains a single quote into the database.

i.e. something like -> windows'xp'

using this query

str=windows'xp'

cmd1.CommandText = "insert into table_a values(" & str & ");"

i even tried replacing ' by \' But that too didnt work.

any help would be appreciated.
thanks,
gomzi.

Hi,
for this you can try it like this,I want to know In which language your doing.
bcz string concatination isdiffer.
str=windows'xp'
cmd1.CommandText = "insert into table_a values(\"" & str & "\");"

try to use this.you have to give the quotation that to double quotes.bcz in your string you have single quote and no need to addslashes

prasanna