Hi!

I'd like to add a function to my web page which gives the user the possibility to delete records from the database.

Therefore, I'd like to have a checkbox next to every record and a "Delete selected records" button in the end of the list.

Every record has a unique identifyer field, and I'd like to pass those values in a form to a ASP page that deletes those records in the database where the unique identifyer is equal to the Request.Form values.

If I call the checkboxes Id234, Id235, ... , Id454, is there a way to extract the identifyer value behind the leading Id chars?

Example, if I have selected three records with identifyers 236, 332 and 401:

Request.Form() = "Id236=on&Id332=on&Id401=on"

Or is there a more simple solution to this problem?

One approach to this problem is to give same name to all the checkboxes, and value will be 236, 332 etc. If user checks any of the checkboxes, then you will get an array in request.form("checkbox_name")

you can access these values with
Request.Form("checkbox_name").Item(0) or you can split the comma separated values.



Om Prakash

Correct me if I'm wrong, but isn't the only values on a checkbox "on" or nothing?

you will get value as "on" when u don't specify the value in checkbox.

<input type=checkbox name=c1 value="test">
<input type=checkbox name=c2>

<%
Response.Write "c1=" & request("c1") - gives "test"
Response.Write "c2=" & request("c2") - gives "on"
%>

Om Prakash

Okey! Thanx Om!

you'll need to set up some query's to comunikate with your db. Is it these query's you are asking about?

1. Ekstract the fields you want from the db
2. present the these records in a form, a page ...
3. Include a button or a checkbox whatever next to each post
4. Finger in the script which deletes the records in the db
5. and that is it!!