View Single Post
  #6 (permalink)  
Old Oct 15th, 2004, 01:51
Monie Monie is offline
Most Reputable Member
Join Date: Feb 2004
Location: Borneo
Age: 27
Posts: 1,608
Blog Entries: 2
Thanks: 0
Thanked 4 Times in 3 Posts
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
%>