Fejltype: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access-driver] Der er for få parametre. Der var ventet 1. /arduous/sub/members/single.asp, line 6
Set Conn = Server.CreateObject("ADODB.Connection") strSQL "SELECT * FROM members WHERE NICK=" & nick, Conn, 1, 3 <- MIN FEJL strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("mdb/lyske.mdb") nick = Request("nick") set rs = Server.CreateObject("ADODB.Recordset") rs.Open strSQL, strDSN, 1 if rs.eof or rs.bof then response.write "<span class=""normal"">" response.write "Intet medlem ved navn: " response.write request("nick") response.write "</span>" else Do until
Set rs = Server.CreateObject("ADODB.RecordSet") strSQL "SELECT * FROM members WHERE NICK=" & nick strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("mdb/lyske.mdb") strSQL = StrSQL & " ORDER BY id Desc" rs.Open strSQL, strDSN, 1
hmm.. det burde fungere.. prøv at smide din
prøv at indsætte nick = Request("nick") for sig selv over koden.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.