can anyone help? i am using vb, 1

[sweetleaf]

can anyone help?

i am using vb, asp and oracle together and when i try to
update a table with a value passed to a com object from an asp page i get the old "ole db multiple step required .." error.
the data is an english product description followed by a french product description separated by a forward slash.
I am sure that the forward slash is causing this.
Does anyone know how i can remedy this?

thanks,

 

[pmulligan]

you can enclose the value of the field in double quotes, but you have to use the ansii value for them ex:
UpdateSQL = "update tblTable set description = '" & chr(34)& request("description&quot & chr(34) & "'"

or you can do a little bit of string manipulation and search for specific characters like "/" and replace it with two of them "//" - and it should update with only one.

 

[sweetleaf]

thanks pmulligan!

thats just what i was looking for. does padding the string with an extra character (ie."/&quot apply to most other problematic characters as well?

thanks,