multiple select

[Ravala]

How can I do multiple select option.
My code is:
<select name="cboOrderTypeBrand" id="cboOrderTypeBrand">
<%
Set objRS = GetOrderTypesRecordSet()
While not objRS.EOF
response.Write("<option value=" & objRS("CODE").Value & ">" & objRS("CODE").Value & "</option>")
objRS.MoveNext
Wend
objRS.Close
Set objRS = Nothing
%>
</select>
Thanks.

 

[Veep]

<select name="cboOrderTypeBrand" id="cboOrderTypeBrand" [b][red]Multiple[/red][/b]>
        <%
        Set objRS = GetOrderTypesRecordSet()
        While not objRS.EOF
            response.Write("<option value=" & objRS("CODE").Value & ">" & objRS("CODE").Value & "</option>")
            objRS.MoveNext
        Wend
        objRS.Close
        Set objRS = Nothing
        %>
        </select>

 

[Tarwn]

Just add "multiple" in your beginning select tag:
<select name="cboOrderTypeBrand" id="cboOrderTypeBrand" multiple>

-T

 

[Tarwn]

To quick for me today veep

 

[Ravala]

But I return just first select element.

 

[Tarwn]

It will pass a comma-delimited list of all the selected elements. So if your select looked like this:

<select name="selColors" multiple">
   <option>red</option>
   <option>blue</option>
   <option>yellow</option>
   <option>green</option>
</select>

And you selected the first and last color, then you could read them on the next page like this:

Response.Write Request.Form("selColors")
'or
Dim color
For Each color in Request.Form("selColors")
   Response.Write color & "<br>"
Next

The first statement would output: red, green
the second statement (for loop) would output:
red<br>
green<br>

-T

 

[Ravala]

I have to pass onSubmit this string as selection formula (sf) to Crystal Report.
I don't know much javascript,
My sf should look like "ORDER_TYPE IN ('type1','type2')

 

[Tarwn]

That would be a javascript question then, not ASP, you can find the javascript forum here: forum216

 

[Scobe]

Hello, my question is related to all of the above.
I have a multiple select statement, passing to another page.
I get the select box data on the 2nd page as - i.e

'Red,Green'

but I am using this field to put in SQL statement for SQL Server, which doesn't work as SQL Server needs the text as
'Red','Green'.

anyone any ideas
regards
Steve

 

[ChrisHirst]

I use a couple functions to split() the string on the comma then add quotes to each word in the array and reconstruct the string and commas,



Chris.

Indifference will be the downfall of mankind, but who cares?

http://www.candsdesign.co.uk

A website that proves the cobblers kids adage.

http://www.cram-system.com

Nightclub counting systems

So long, and thanks for all the fish.

 

[Genimuse]

If they're all strings (which with the ORDER IN sql I'd assume they are) you could do it like this (separated into multiple lines to make it more clear, you can merge the whole concatenation into one to speed it up a bit):

strSQL = strSQL & "ORDER_TYPE IN ('"
strSQL = strSQL & Replace(Request.Form("cboOrderTypeBrand"), ",", "','")
strSQL = strSQL & "')"

This would put the beginning parenthesis and single quote at the beginning, then change something like

red,green,blue

into

red','green','blue

using Replace(), and then it would add the ending single quote and parenthesis to the end.

All of this assumes what you meant was that you needed a way to do this in VBScript on the server (in ASP), which is what I think you meant, not Javascript.