Redirect problem asp
Hejsa NG.Nogen der kan se en fejl i dette:
<%if mode = "poster" then%>
<%
Response.Buffer = True
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../db/data.mdb")
If Request.QueryString("id") <> "" Then
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM poster WHERE (id = " & Request.QueryString("id") & ")"
Response.Write strSQL
rs.Open strSQL, myConn, 1, 3
If Not (rs.BOF Or rs.EOF) Then
rs("Hits") = rs("Hits") + 1
rs.Update
rs.Close
myConn.Close
Set rs = Nothing
Set myConn = Nothing
Response.Clear
Response.Redirect("poster.asp?mode=view&id=" & Request.QueryString("id") & "")
End If
End If
%>
Jeg får følgende fejl:
SELECT * FROM poster WHERE (id = 1732 )
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(id = 1732 )'.
/redirect.asp, line 125
som er denne linie:
If Not (rs.BOF Or rs.EOF) Then
