On an .ASP Webpage I allow users to select more than one option from a list box. To retrieve this information I use the Split Function i.e.
<% strSQL = SELECT APP_JOB FROM TBLAPPLICANTS Set RSAPPLICANT = Server.CreateObject("ADODB.Recordset") RSAPPLICANT.open strSQL,Conn Dim strjob strjob = RSAPPLICANT("APP_JOB") choice=Split(strjob, ",") %>
For example the user selects two options i.e Freelance, Self-Employed that I can retrieve using the For Next Loop.
<form id="form1" name="form1" method="post" action=""> <select name="mnustylisttype" size="4" multiple="MULTIPLE" class="DropdownFields"> <% For i = LBound(choice) TO UBound(choice) %> <option value="<%=choice(i)%>"><%=choice(i)%></option> <% Next %> </select> </form>
The options actually come from a list drlistAPP_TYPE a Table that contains the following:
My question is how do I retreive the options selected by the user i.e. Freelance, Self-Employed and the remaining option available in the drlistAPP_TYPE Table i.e. Contract?
Any help would be good - Thanks Guys