<!-- #include file="app_inc/db.asp" -->

<%
radio1=request.form("radio1")
radio2=request.form("radio2")
radio3=request.form("radio3")
radio4=request.form("radio4")
radio5=request.form("radio5")
radio6=request.form("radio6")
radio7=request.form("radio7")
radio8=request.form("radio8")
radio9=request.form("radio9")
radio10=request.form("radio10")
radio11=request.form("radio11")
radio12=request.form("radio12")
radio13=request.form("radio13")
radio14=request.form("radio14")
radio15=request.form("radio15")
radio16=request.form("radio16")
radio17=request.form("radio17")
texto1=request.form("texto1")
texto2=request.form("texto2")
texto3=request.form("texto3")

id_cf_entrevistador=request.form("id1")
id_status_treinamento=request.form("id2")

call db_open()
respondeu=1

query = "insert into CF_PESQUISA_QUALIDADE (ID_CF_ENTREVISTADOR,radio1,radio2,radio3,radio4,radio5,radio6,radio7,radio8,radio9,radio10,radio11,radio12,radio13,radio14,radio15,radio16,radio17,texto1,texto2,texto3,respondeu,id_status_treinamento)"
query = query & "values ('" & id_cf_entrevistador & "','" 
query = query & radio1 & "','"
query = query & radio2 & "','"
query = query & radio3 & "','"
query = query & radio4 & "','"
query = query & radio5 & "','"
query = query & radio6 & "','"
query = query & radio7 & "','"
query = query & radio8 & "','"
query = query & radio9 & "','"
query = query & radio10 & "','"
query = query & radio11 & "','"
query = query & radio12 & "','"
query = query & radio13 & "','"
query = query & radio14 & "','"
query = query & radio15 & "','"
query = query & radio16 & "','"
query = query & radio17 & "','"
query = query & texto1 & "','"
query = query & texto2 & "','"
query = query & texto3 & "','"
query = query & respondeu & "','"
query = query & id_status_treinamento & "')"


con.execute(query)

call db_close()

response.redirect "TakeSurveyActionComplete.asp"
%>