Hai spinal...
When you write this, <input type=checkbox name=delete value="
<%=admin("ID")%>">,is it reffering to my recordset for adnmin ID,because my code for that is
<%=(admin.Fields.Item("ID").Value)%>. I am a little bit confuse here
One more..
For the code below, do I have to change anything there?
I dont understand the "SCRIPT_NAME"?
- Code: Select all
?delete=<%=admin("ID")%>">delete me!
One last thing...
This is my rs connection, so..you mean I just have to put the code inside it like this??? Can you guide me if i am wrong?
i dont understand this part:
WHERE (ID=" & record & ")"
- Code: Select all
<!!--My recordset to display all data inside userlist.mdb-->
<%
set admin = Server.CreateObject("ADODB.Recordset")
admin.ActiveConnection = MM_AdminRegister_STRING
admin.Source = "SELECT * FROM userlist"
admin.CursorType = 0
admin.CursorLocation = 2
admin.LockType = 3
admin.Open()
admin_numRows = 0
For Each record In Request("Delete")
admin.Open "DELETE * FROM userlist WHERE (ID=" & record & ")"
Next
%>