How do you insert multiple records into a database?

[DonCL]

Hello, i have a form where members can purchase products from. the format is like this:
qty-----product------price----select to purchase----
3--------shirt-------5.00-------form checkbox-------
1--------pants-------10.00-------form checkbox------

my question is: how can i make it so when a user checks multiple checkboxes, those products will be inserted into multiple rows in my database? i am using Access. when i submit the form, only one record goes in, i need multiple records to be inserted in case the customer buys more than one product. Thanks!

 

[schase]

http://www.charon.co.uk/UltradevDownloads_UD4.asp

Multiple Insert/Update "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart

 

[DonCL]

thanks for the link, but i should have mentioned that i need it in jsp. is there any way to do this?

 

[schase]

not sure, you could look on macromedia's site possibly. "Damn the torpedoes, full speed ahead!"

-Adm. James Farragut

Stuart