Fejl ??!??
Jeg får denne fejl :
Microsoft OLE DB Provider for ODBC Drivers fejl '80040e07'
[Microsoft][ODBC Microsoft Access-driver] Datatyperne stemmer ikke overens i kriterieudtrykket.
/tips_tip.asp, linje 17
i denne kode:
<%
if session("ID")>0 then %>
<%
If Request.Form("Action") = "Tip" Then
'intGamenr = GetGameNumber(Now())
strData = Request.form("T1")
intData = Request.form("T2")
set DB = Server.CreateObject("ADODB.Connection")
DB.open "Driver={Microsoft Access Driver (*.mdb)};"&_
"DBQ="&server.mappath("db/tips.mdb")&";"&_
"DefaultDir="&server.mappath("./")&";FIL=MS Access;"
SQL = "SELECT * FROM Spil30 WHERE ID = " & Session("ID") & ""
Set RS = DB.Execute(SQL)
if RS.eof then
SQL = "INSERT INTO Spil30 (ID, strDATA, intDATA) VALUES ('" & Session("ID") & "', '" & strData & "', '" & intData & "')"
else
SQL = "UPDATE Spil30 SET strDATA = '" & strData & "', intDATA = '" & intData & "' WHERE ID = '" & Session("ID") & "'"
end if
RS.Close
Set RS=nothing
DB.Execute(SQL)
DB.Close
Set DB=nothing
response.redirect ("tipsstart.asp")
End if
%>