You can loop through your results, and send an update for each one. Do you
need to update those who don't attend?
I'll assume you don't have to update those who don't.
So on your form you'd have.....
Joe Blow <input type=checkbox name=ATTENDED value=1>
Fred Smith <input type=checkbox name=ATTENDED value=8>
Jen Jones <input type=checkbox name=ATTENDED value=3>
Gerald Springer<input type=checkbox name=ATTENDED value=99>
(Note that the value is the registrants ID from the database)
When the page is submitted the value of Request.Form("ATTENDED") will be a
comma delimited string of the selected values, so assuming just Joe, Jen and
Gerald are checked then it would equal "1,8,99" So, split it into an array
and update the database
Dim arrRegistrants
Dim iLoop
Dim sSQL
arrRegistrants=Split(Request.Form("ATTENDED"),",")
for iLoop=0 to Ubound(arrRegistrants)
sSQL="UPDATE tblWhatever Set Attended=1 WHERE RegistrantID=" &
arrRegistrants(iLoop)
CN.Execute sSQL 'Assuming CN is a valid and open connection object
next
You could also send a single sql statement along the lines of
sSQL="UPDATE tblWhatever SET Attended=1 WHERE RegistrantID IN (" &
Request.Form("ATTENDED") & ")"
which would look like this
UPDATE tblWhatever SET Attended=1 WHERE RegistrantID IN (1,8,99)
I think that's right, check BOL.