Hi Everyone
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:
1 Freelance
2 Self-Employed
3 Contract
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