Hej jeg har flg kode som ikke virker, håber der er nogle som kan hjælpe mig
<% ' ######################################## Ret ########################################
If Request.QueryString("acc") = "ret" Then %>
<!-- #include file="includes/connadd.asp" -->
<%
Dato = "" & Request.form("Aar") & "-" & Request.form("Mdr") & "-" & Request.form("Dag") & ""
SQL = "Update u_zonen_konkurrence_facts set "
SQL = SQL & "Nr= '" & Request.Form("Nr") & "', "
SQL = SQL & "Dato= 'Response.Write " & Dato & "', "
SQL = SQL & "Q1= '" & Request.Form("Q1") & "', "
SQL = SQL & "Q2= '" & Request.Form("Q2") & "', "
SQL = SQL & "Q3= '" & Request.Form("Q3") & "', "
SQL = SQL & "Q4= '" & Request.Form("Q4") & "', "
SQL = SQL & "Q5= '" & Request.Form("Q5") & "', "
SQL = SQL & "Q1-t= '" & Request.Form("Q1-t") & "', "
SQL = SQL & "Q2-t= '" & Request.Form("Q2-t") & "', "
SQL = SQL & "Q3-t= '" & Request.Form("Q3-t") & "', "
SQL = SQL & "Q4-t= '" & Request.Form("Q4-t") & "', "
SQL = SQL & "Q5-t= '" & Request.Form("Q5-t") & "', "
SQL = SQL & "Award-pic= '" & Request.Form("Awardp") & "', "
SQL = SQL & "Award-mes= '" & Request.Form("Awardmes") & "' "
SQL = SQL & "Where ID = '" & Request.Querystring("ID") & "'"
' SQL sætning eksekveres
Conn.Execute(SQL)
Response.redirect("secret.asp?side=ok")
End If %>
Den fejl jeg får er:
Error Type:
ADODB.Connection.1 (0x80004005)
SQLState: 4 Native Error Code: 1064 [TCX][MyODBC]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '-t= '', Q2-t= '', Q3-t= '', Q4-t= '', Q5-t= '', Award-pic= '1.j
/Admin/konkurrence.asp, line 247