I have been trying to find the problem but still no luck.......I really need help here the error message:
Error Type:
ADODB.Recordset (0x800A0CC1)
Item cannot be found in the collection corresponding to the requested name or ordinal.
/MyWeb/SCdelete.asp, line 32
here's my code:[u]
Select name to delete.
<html>
<body>
<%
Dim Conn, Rs, sql
Set Conn = Server.CreateObject("ADODB.Connection")
Set Rs = Server.CreateObject("ADODB.Recordset")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("cartdb.mdb")
sql= "SELECT * FROM CartTable;"
Rs.Open sql, Conn
Response.Write ("<FORM name='Delete' method='post' action='Deletetest.asp'>")
Response.Write ("<table border=1 cellspacing=0>")
Response.Write ("<tr>"&"<td colspan='3' align='center'>"&"Select and click delete if your mind change"&"</td>"&"</tr>")
for each x in rs.Fields
response.write("<th>" & ucase(x.name) & "</th>")
next
Do While not Rs.EOF
Response.Write ("<tr>")
Response.Write ("<td>"&"<input type='radio' name='ID' value="&Rs("itemID")&">"&"</td>")
Response.Write ("<td>"&Rs("x.value")&"</td>")
Response.Write ("</tr>")
Rs.MoveNext
Loop
Response.Write("<tr>"&"<td colspan='3' align='center'>"&"<input type ='submit' name='submit' value='Delete' onClick='return validate();'>"&"</td>"&"</tr>")
Response.Write "</table>"
Response.Write ("</form>")
Rs.Close
Set Rs = Nothing
Set Conn = Nothing
%>
</body>
</html>
I 've checked almost everything PLEASE help