I'm working on a project for my school and i want to make it possible to delete several records at once.
Problem is I'm just a bigginer with ASP 3.0
So if you can help me I will be very grateful

You could run a query to get all the record primary keys and create a list of checkboxes in a form using this with names like DeleteRecord1, DeleteRecord2, ... (the 1, 2 etc being the primary key of each record).

Then on the page the form is submitted to, loop through the Request.Form collection and check for any fields that have a name that matches this naming convention & execute a delete query.

HTH,

Chris

Hello,

  Loop thru recordset and form the checkboxes with the value contains primary key field. Assign the same name to all checkbox(ex:chk1).When u submit the form, the checkbox values are passed with a comma seperated values. Those checkboxes are clicked onlu those Values of the checkboxes passed.

So, u split the string into an array and do u r coding.



---------
Rajani

http://dmxzone.com/ShowDetail.asp?NewsId=3369 -- You might want to read this! It has a working example .. just go through it .. am sure you would understand it yourself.

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Ok, I got it working. Thx so much!

XXL

Glad you go it working. I would like to add to rajanikrishna's post: Coding the same named checkboxes is a very handy and quick way to post a comer delimited string (of the checked values) to the destination page. I would like to give you an example of a DELETE WHERE IN statement (there is no need to split the string etc)

sql = "DELETE FROM tblName WHERE ID IN (" & request.form("idString") & ");"



Wind is your friend
Matt