ASP sees " as the end of the string. So, double it up.
And stop using a recordset to affect data!
connectionObject.execute "UPDATE mytable SET name='my name""' WHERE id =
100", , 129
(Reverse address to reply.)
"Lin Ma" <abc.com> wrote in message