can't insert data into access DB

while updating the db with asp
it gives me error when the formating of the contents entered in the editor contains some " or ' - as i think - so ..
this is the update query ...
"
set q=conn.execute("update user set user.content = '"& str & "' WHERE id=" & session("id") & " " )
"
i think when it meets the (") in the text it ends the query & the error happens ...

the "server.htmlencode" converts it to a shape to be shown as tags in the web page & when leaving it without converting the (") makes error

please help me ... i'm running out of time
thanks in advance ...

Tue, 07/15/2003 - 06:01

antlane

Joined: 27/12/2006

Posts: 5

RE: can't insert data into access DB

It's an apostrophe (') which is causing the error. In SQL, you need to convert all single apostrophes to double ones:

set q=conn.execute("update user set user.content = '"& Replace(str, "'", "''") & "' WHERE id=" & session("id") & " " )

Sat, 07/19/2003 - 07:15

damshity

Joined: 15/07/2003

Posts: 2

RE: can't insert data into access DB

thanks , u r a life saver .. the problem solved ...