Choose multiple value/name from drop down list.

[19511950]

Hi,
I can choose multiple rows from drop down list and get value into the query.
select * from table where StateID in (1,15,17).

Also I need to pick the State Name in the same sequence: "You choose ALABAMA,INDIANA,KANSAS states."
Can I get the value of ID?

<select name=Date2 multiple>
<option value="1" id="ALABAMA">ALABAMA</option>
<option value="3" id="ARIZONA">ARIZONA</option>
<option value="15"id="INDIANA">INDIANA</option>
<option value="16"id="IOWA">IOWA</option>
<option value="17"id="KANSAS">KANSAS</option>
</select>

Regards,
Mark

 

[FesterSXS]

You cant access the ID using ASP. But, how about changing the values to "1-ALABAMA", "3-ARIZONA", "15-INDIANA", etc.

You could then separate the state names and id's in the page that processes the form.

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[19511950]

How to do it?

 

[FesterSXS]

which bit cant you do?

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[19511950]

I need both. (1,15,17) and (ALABAMA,INDIANA,KANSAS)

 

[FesterSXS]

Try this - it requires that your ID and state name are separate by a comma.

eg) <option value="1,Arizona">

<%
Dim strTest, strStates, strID, i

strTest = Split(Request.Form("Date2"),",")

For i=0 To UBound(strTest)
  If (i Mod 2) Then
    If strID <> "" Then
      strID = strID & "," & strTest(i)
    Else
      strID = strTest(i)
    End If
  Else
    If strStates <> "" Then
      strStates = strStates & "," & strTest(i)
    Else
      strStates = strTest(i)
    End If
  End If
Next

Response.Write strID & "<BR>" & strStates
%>

Tony
_______________________________________________________________

http://www.SpiraxSarco.com/

 

[19511950]

Tony,

Thank you very much.It works.

Mark