Forums

This topic is locked

How do you do multiple inserts from one form?

Posted 09 Feb 2003 03:38:42
1
has voted
09 Feb 2003 03:38:42 Vincent Lee posted:
Hello,
Thanks in advance for your assistance. I have a form that is part of an ASP page. It's form objects consists of of pulldown lists, checkboxes, etc.
The fields consist of a user_id (dropdown box), skills ( 25 different checkboxes), start_date (text field), and end date (text field).
What should happen is if a user checks 3 different checkboxes, then there will be 3 inserts into the table.

So for example,
Usr_ID Skills Start_Date End_Date
1 Type 2001/01/01 2001/02/01
1 Read 2001/01/01 2001/02/01
1 Kick 2001/01/01 2001/02/01

The way that the form is now...there is only one insert but the skill column is NULL. Do you know if there is a way to do what I am needing? If you need the code, then please email me and I will send it to you. Thanks so much for your help.

Vincent

Reply to this topic