I have a <select> object with N <option>s. I want to store the entire list to the (MS SQL) database. The stored procedure will take care of database integrity issues. The exact syntax and what "request.form" objects/properties/methods/etc. that are available eludes me.
I know what I want to do: upon SUBMIT, create a new recordset, put ALL the values from the <select> in it then run an SQL stored procedure (no prob' here) to stuff them into the DB.
I understand the response object receives only those radio button & checkbox values that are "selected" - NOT the complete radio button (checkbox) set ... - I assume this is also true of <select>. If so, easy enough to set the "selected" property in script just prior to SUBMIT.
How do I tell how many <options> I have so I can run a loop? In other words, are the same HTML form object properties & methods availble after the form is passed to the server?
I think I don't want to use "recordsetobject.Update" or it's batch variant. Instead, I use "recordsetobject.execute 'stored_procedure' ". Yes?