Update Multiple Records with One submit

[Olivia Towery]

SQL 6.5 Database

I have a list of registrants and I want to use a check box after each record
to show those who attend and then post all with one submit button.

Any help is appreciated.

--
Olivia Towery
Tower Internet Management

[Tom B]

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.


"Olivia Towery" <pr*****@timwebs.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...

SQL 6.5 Database

I have a list of registrants and I want to use a check box after each record to show those who attend and then post all with one submit button.

Any help is appreciated.

--
Olivia Towery
Tower Internet Management

[Olivia Towery]

Thanks Tom. But what if I do want to be able to uncheck a box and have the
db updated? Can this be done?

"Tom B" <sh*****@hotmail.com> wrote in message
news:OB**************@TK2MSFTNGP12.phx.gbl...

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.


"Olivia Towery" <pr*****@timwebs.com> wrote in message
news:us**************@TK2MSFTNGP09.phx.gbl...

SQL 6.5 Database

I have a list of registrants and I want to use a check box after each

record

to show those who attend and then post all with one submit button.

Any help is appreciated.

--
Olivia Towery
Tower Internet Management