Hello fellows,

I faced the difficulty that I have to update the records which are 
only checked.  I have a page lists projects and I am trying to 
put a column of check box for each record. Then when user check several
records and click update button, the selected records will be updated
with some value in a field.  Can anyone give me suggestions or coding?
Thank you.

James

You could give the checkbox the value of the primary key.
On the server: 
Write a function with a command object that updates one record at a
time.
Call the function for each checkbox that returns a value

Regards,

Gerhard Wentink

>-----Original Message-----
>From: James Kim [mailto:james@k...] 
>Sent: Friday, August 30, 2002 7:00 PM
>To: ASP Databases
>Subject: [asp_databases] Help with Check box in a Query
>
>
>Hello fellows,
>
>I faced the difficulty that I have to update the records which are 
>only checked.  I have a page lists projects and I am trying to 
>put a column of check box for each record. Then when user check several
>records and click update button, the selected records will be updated
>with some value in a field.  Can anyone give me suggestions or coding?
>Thank you.
>
>James
>