update mulitple rows in SQL 2K
Some background: I use a stored procedure to get the data from SQL, and a loop using ASP to display a table with multiple columns in rows based on site number and unit number. The first column of each unique row contains a checkbox, and subsequent columns are either editable text-box fields or simply display the data.
My goal: I want the user to be able to edit the data in multiple columns and/or multiple rows, then put a check in the checkbox for each row to be updated, then press SUBMIT and have the updates take place.
Future goals: to be able to do some data verification and prompt the user for correction (ie: date field value is not a date) prior to the update.
I'm new to ASP, but strong in SQL. The update stored procedure should be a piece of cake, but I'm not sure how to get the data into parameter form for multiple rows. I have been able to pass the data from multiple text boxes on previous pages where there was a single row with a radio button and text-boxes into SQL without any problem, and am certain I can get the data from a single row passed into a stored proc without any problem. It is the multiple rows part that I'm stuck on.
Any ideas? I'm not even sure my approach is correct. It seemed like a good idea until I hit the update piece, and I have concerns about being able to verify the data is correct once I get to that part. I've done a lot of searching online and in books without finding what I'm looking for, and hope someone here has solved this problem in the past. Thanks for your help.