Now I'm at home, i've sorted it guys, just get this one now...
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
doncaster/teams/default.asp, line 38
<html>
<head>
<title>RL Teams</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<%
'Dimension Variables
Dim adoCon
Dim rsTeam
Dim strSQL
'Create ADO Conn Obj
Set adoCon = Server.CreateObject("ADODB.Connection")
'DNS-Less Connection
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="& Server.MapPath("/doncaster/db/team.mdb")
'Create ADO Recordset
Set rsTeam = Server.CreateObject("ADODB.Recordset")
'Initialise strSQL variable
strSQL = "SELECT team.* FROM team;"
'Open Recordset
rsTeam.Open strSQL, adoCon
Response.Write ("<table border='1' bordercolor='black' cellpadding='0'>")
'Loop recordset
Do While not rsTeam.EOF
'Write the HTML
Response.Write ("<tr>")
Response.Write ("<td>")
Line 37 - Response.Write ("<a href=""view_team.asp?Id_No=" & rsTeam("Id_No") & """>")
Response.Write (rsTeam("Name"))
Response.Write ("</a>")
Response.Write ("</td>")
Response.Write ("</tr>")
Response.Write ("<tr>")
Response.Write ("<td>")
Response.Write (rsTeam("League"))
Response.Write ("</td>")
Response.Write ("</tr>")
rsTeam.MoveNext
Loop
'Reset server variables
rsTeam.Close
Set rsTeam = Nothing
Set adoCon = Nothing
%>
</body>
</html>
What else is there??
Topic Options
Post Options
Thanks(0)
