The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Can I ask you how to insert multiple row values in one SUBMIT?for example I have cbprob=1,cbprob=2,cbprob=3 and my query is
INSERT INTO tbltest (pid) VALUES ('"&Request.Form("cbprob")&"'). How am i going to insert the three values?

It's pretty hard to teach you how to do something when we don't really know anything about what you are trying to achieve. What database are you using, and what is the structure of the table you're inserting into? Also what does the form field html look like and are you posting (POST) or getting (GET) the results?

In the big picture, you'll need to collect all of the checkbox results from your form and then put them into some sort of array or series of variables. Then, if you're following my suggestion of using a related table for the checkbox results, you'll need to create a loop and insert each result so that there is a separate row for each checkbox.

@joeyramirez: Can you show a sample of what the checkboxes look like (in HTML) as they render from that code? It looks to me like they will all have the same name (cboprob) and we need to make sure that they are unique so they can be requested and inserted into a SQL insert query.

Thanks, can you look at the html and find out what the name attributes are for the checkboxes? My concern is that they're all the same value in which case we need to make them unique somehow. Maybe doing something like the following:

This is roughly how I would do it so it will require some tweaking, particularly (checking for syntax errors I may have introduced) and adding some sort of ID to accompany the inserted cboprob values so you can relate that to a particular customer or trouble ticket.