splitting textfield and checkbox array
Posted on 2007-10-15
I have a form which is built dynamically from a recordset from SQL server. The number of results may vary but have the following format. In a table, column 1 displays a telephone number, column 2 displays a textfield (description) that the user adds adds their description to, column 3 holds a checkbox (mark_number) that holds the number that is displayed in column 1.
The idea is that the user can check any of the numbers they are marking as personal, so they enter a value in the description field and check the box, any number marked gets added to a SQL table combining the texfield and the checkbox values.
My question is what is the best way to tie a textfield and checkbox together and pass the values to a Stored Procedure, normally I would split say the description field array using the Split function but I'm not sure how to get both description and mark_number values tie together. And also is it best to split before passing to SP within the ASP or split in the SP using SQL