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.
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.
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?
try to check out the link might help...
https://www.experts-exchange.com/questions/20450556/request-form-with-a-local-variable.html
https://www.experts-exchange.com/questions/20486516/Update-an-Access-database-thru-a-submit-form-using-ASP.html
Happy programming...
https://www.experts-exchange.com/questions/20450556/request-form-with-a-local-variable.html
https://www.experts-exchange.com/questions/20486516/Update-an-Access-database-thru-a-submit-form-using-ASP.html
Happy programming...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.