Loui

Boa tarde.

Estou tentando atualizar algumas informações no BD, porém esta retornando o erro Expected End of statement.
eis o código da pagina:

idquiz = request.querystring("idquiz")
titulo = Request.QueryString("titulo")
ativo = Request.QueryString("atv")
link = Request.QueryString("link")
per1 = Request.QueryString("per1")
o1p1 = Request.QueryString("o1p1")
o2p1 = Request.QueryString("o2p1")
o3p1 = Request.QueryString("o3p1")
per2 = Request.QueryString("per2")
o1p2 = Request.QueryString("o1p2")
o2p2 = Request.QueryString("o2p2")
o3p2 = Request.QueryString("o3p2")
per3 = Request.QueryString("per3")
o1p3 = Request.QueryString("o1p3")
o2p3 = Request.QueryString("o2p3")
o3p3 = Request.QueryString("o3p3")
rc1 = Request.QueryString("rc1")
rc2 = Request.QueryString("rc2")
rc3 = Request.QueryString("rc3")

up_prod = up_prod & "UPDATE quiz set titulo = '" & titulo
up_prod = up_prod & "', ativo = '" & ativo 
up_prod = up_prod & "', link = '" & link 
up_prod = up_prod & "', pergunta1 = '" & per1 
up_prod = up_prod & "', r1p1= '" & o1p1
up_prod = up_prod & "', r2p1= '" & o2p1
up_prod = up_prod & "', r3p1= '" & o3p1 
up_prod = up_prod & "', pergunta2= '" & per2 
up_prod = up_prod & "', r1p2= '" & o1p2
up_prod = up_prod & "', r2p2='" &o2p2 
up_prod = up_prod & "', r3p2 = '" & o3p2
up_prod = up_prod & "', pergunta3= '" & per3 
up_prod = up_prod & "', r1p3='" &o1p3
up_prod = up_prod & "', r2p3= '" &o2p3 
up_prod = up_prod & "', r3p3 = '" & o3p3 
up_prod = up_prod & "', rc1='" & rc1 
up_prod = up_prod & "', rc2='" & rc2
up_prod = up_prod  &"', rc3='" & rc3 
up_prod = up_prod & "' where idquiz = " & idquiz
Set up = abredb.execute(up_prod)

Mas se eu retirar a parte onde tem r1p1, r2p1, r3p1.. r1p2... ou seja, as respostar, o código roda sem poblemas.
e mesmo se eu colocar um
response.write(up_prod)
response.end()
pra verificar a saída ele da o erro