lille Fejl... hjælp..
Nogle der kan se hvad der er galt her:<%
dim conn
Set conn = Server.CreateObject("ADODB.Connection")
DBPath = "DBQ=" & server.mappath("data.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & DBPath
brugerid = Request.form("brugerid")
uge = DatePart("ww",Now())
k1 = Request.form("k1")
k2 = Request.form("k2")
k3 = Request.form("k3")
k4 = Request.form("k4")
k5 = Request.form("k5")
k6 = Request.form("k6")
k7 = Request.form("k7")
k8 = Request.form("k8")
k9 = Request.form("k9")
k10 = Request.form("k10")
k11 = Request.form("k11")
k12 = Request.form("k12")
k13 = Request.form("k13")
SQL = "INSERT INTO kuponer (brugerid,uge,k1,k2,k3,k4,k5,k6,k7,k8,k9,k10,k11,k12,k13 ) values ('" & navn & "','" & uge & "','" & k1 & "','" & k2 & "','" & k3 & "','" & k4 & "','" & k5 & "','" & k6 & "','" & k7 & "','" & k8 & "','" & k9 & "','" & k10 & "','" & k11 & "','" & k12 & "','" & k13 & "')"
conn.execute(SQL)
conn.close
set conn = nothing
%>
Den kommer med denne error:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/tips/addkupon2.asp, line 34
