indset i access database problem
<%spgID = Request.Form("spgID")
replyID = Request.Form("replyid")
tekst = Request.Form("tekst")
If tekst = "" THen
Response.Redirect "forum_reply.asp?id=" & spgid & "&error_code=1"
End if
converted_date = now
Set Conn = Server.CreateObject("ADODB.Connection")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = DSN & "DBQ=" & Server.MapPath("../../db/clubrace.mdb")
Conn.Open DSN
strSQL = "Insert into reply ("
strSQL = strSQL & "ReplyPoster, "
strSQL = strSQL & "ReplyDate, "
strSQL = strSQL & "ReplyText, "
strSQL = strSQL & "ReplyTo, "
strSQL = strSQL & "SpgID) "
strSQL = strSQL & "values( "
strSQL = strSQL & "'" & Session("userid") & "', "
strSQL = strSQL & "'" & converted_date & "', "
strSQL = strSQL & "'" & tekst & "', "
strSQL = strSQL & "'" & replyid & "', "
strSQL = strSQL & "'" & spgid & "')"
Conn.Execute(strSQL)
Conn.Close
Set Conn = Nothing
%>
jeg får følgende fejl med denne kode:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07)
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
/clubrace/forum_reply_funk.asp, line 29
linie 29 er:
Conn.Execute(strSQL)
