That's what I tried. Here's my exact code:

q_clientnum = Trim(Session("xclient"))
q_name = Request.Form("q_name")
q_subject = Request.Form("q_subject")
q_comments = Request.Form("xcomments")
q_contact = Request.Form("xcontact")
q_navigate = Request.Form("xeasynav")
q_rating = Request.Form("xrating")
q_speed = Request.Form("xspeed")

'Get connected to the database.
set recset = Server.CreateObject("ADODB.Connection")
recset.Open "sf_login"

theSQL = "insert into comments "
theSQL = theSQL & "(comid,clientnum,name,subject,"
theSQL = theSQL & "contact,comments,navigate,rating,speed)"

theSQL = theSQL & " values ('" & q_comid & "','" & q_clientnum & "','" & q_name & "','" & q_subject & "'," & q_contact & ",'" & q_comments & "'," & q_navigate

theSQL = theSQL & ",'" & q_rating & "','" & q_speed & "')"
Response.Write theSQL

set userSet = recset.Execute(theSQL)


I've tried double and triple quotes. Any suggestions?