Link to home
Start Free TrialLog in
Avatar of jkatz2
jkatz2

asked on

Multiple Insert to table

I have developed a training registration web app. I am tryiing to add attendance tracking to it. The problem I have is when the trainer selects the class, they get a listing (detail page) of all the students who have registered. I added a field called (attended - yes \ no) to my table and add a check box to the listing. When I submit the form, all the students update 1 record.

How do I do submit multiplte records to the database. I saw something that showed how to update multiplte table (with 1 record) utlizing commands, but I have not used this function yet.
Avatar of Saqib Khan
Saqib Khan
Flag of United States of America image

jkatz2 I need more Details about your Questions.
What you trying to say this You want to update MULTIPLE Tables by doing one Click or Multiple Fields within one Table?

if Multiple Tables Then run your Code Line BY Line to do whatever you want, if Updating one Table and Multiple Fields then all you have to do this Update/Modify your Sql Statement.

Let me know what you need.
Avatar of jkatz2
jkatz2

ASKER

I need to update 1 table with several records. I have a listing of customers Fname \ Lname \ ect, and a field (attended) that needs to be updated for each record. There can be up to 20 records showing?

ASKER CERTIFIED SOLUTION
Avatar of Jim M
Jim M
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial