Forum Moderators: open
this is the error
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/stadium/displayEvent1.asp, line 25
and this my coding:
<%@ LANGUAGE="VBSCRIPT"%>
<html>
<head>
anybody knows how to solve this?
<title>Data From Database</title>
</head>
<body>
<%
Dim conn, rsDisEvent, sqls
set conn = server.CreateObject ("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & server.MapPath ("stadium.mdb")
set rsDisEvent = server.CreateObject ("ADODB.Recordset")
sqls = "SELECT * FROM [Events]"
rsDisEvent.Open sqls, conn , 3 , 3
Response.write("<table border=1>")
while NOT rsDisEvent.EOF
Response.write("<tr>")
Response.write("<td>")
Response.write(rsDisEvent("Event"))
Response.write("</tr>")
Response.write("</td>")
rsDisEvent.MoveNext()
Wend
Response.write("</table>")
%>
</body>
</html>
