How do I loop through a comma-separated list?

[Christina]

I have a post-form that holds a listbox with mulitple selected items. When
the form is posted to the server ASP file, I want to loop through the
selected items, to insert each of them into a table. How do I do that?

If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

[UncleWobbly]

if you then split that list into an array yo then only need a simple loop to
grab 'em all:

myarray=split(R equest.Form("Li stBox"))

for n=0 to ubound(myarray)
' ... now each of the items is accessed as ;
myarray(n)
next
"Christina" <ha********@hot mail.con> wrote in message
news:eN******** ******@TK2MSFTN GP09.phx.gbl...

I have a post-form that holds a listbox with mulitple selected items. When
the form is posted to the server ASP file, I want to loop through the
selected items, to insert each of them into a table. How do I do that?

If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

[Ray at]

I believe that the items are probably separated by a comma and a space
actually, yes? What you'd want to do is create an array.

<%
sVal = Request.Form("L istbox")
''sVal = "Joe, Bob, Tom, Phil, Toby" for argument's sake

ArrayOfValues = Split(sVal, ", ")

For i = 0 To UBound(ArrayOfV alues)
Response.Write "Value " & i & " is " & ArrayOfValues(i ) & "<br>"
Next
%>

Ray at work


"Christina" <ha********@hot mail.con> wrote in message
news:eN******** ******@TK2MSFTN GP09.phx.gbl...

I have a post-form that holds a listbox with mulitple selected items. When
the form is posted to the server ASP file, I want to loop through the
selected items, to insert each of them into a table. How do I do that?

If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

[UncleWobbly]

of course that should read

myarray=split(R equest.Form("Li stBox"),",")

soz

"UncleWobbl y" <he***@talk21.c om> wrote in message
news:40******** *************@l ovejoy.zen.co.u k...

if you then split that list into an array yo then only need a simple loop to grab 'em all:

myarray=split(R equest.Form("Li stBox"))

for n=0 to ubound(myarray)
' ... now each of the items is accessed as ;
myarray(n)
next
"Christina" <ha********@hot mail.con> wrote in message
news:eN******** ******@TK2MSFTN GP09.phx.gbl...

I have a post-form that holds a listbox with mulitple selected items. When the form is posted to the server ASP file, I want to loop through the
selected items, to insert each of them into a table. How do I do that?

If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

[Roland Hall]

"UncleWobbl y" wrote:
: of course that should read
:
: myarray=split(R equest.Form("Li stBox"),",")

or:
myarray=split(R equest.Form("Li stBox"),", ")
....if there is actually a space in it as Ray mentioned.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

[TomB]

While admittedly Ray's solution is the correct one. If you are just putting
them in a table, you could do something like....

<table>
<tr>
<%
sVal=Request.Fo rm("Listbox")
Response.Write "<td>" & Replace(sVal,", ","</td><td>") & "</td>"
%>
</tr>
</table>

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

I believe that the items are probably separated by a comma and a space
actually, yes? What you'd want to do is create an array.

<%
sVal = Request.Form("L istbox")
''sVal = "Joe, Bob, Tom, Phil, Toby" for argument's sake

ArrayOfValues = Split(sVal, ", ")

For i = 0 To UBound(ArrayOfV alues)
Response.Write "Value " & i & " is " & ArrayOfValues(i ) & "<br>"
Next
%>

Ray at work


"Christina" <ha********@hot mail.con> wrote in message
news:eN******** ******@TK2MSFTN GP09.phx.gbl...

I have a post-form that holds a listbox with mulitple selected items. When the form is posted to the server ASP file, I want to loop through the
selected items, to insert each of them into a table. How do I do that?

If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

[Ray at]

What I'm wondering is if the separator is done by the server or if the
browser chooses the delimiter and posts the data with it. I ~believe~ that
the browser submits data like:

select=a&select =b&select=c, etc. and it's the ASP process that returns that
as comma+space delimited values.

Ray at work
"Roland Hall" <nobody@nowhere > wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

"UncleWobbl y" wrote:
: of course that should read
:
: myarray=split(R equest.Form("Li stBox"),",")

or:
myarray=split(R equest.Form("Li stBox"),", ")
...if there is actually a space in it as Ray mentioned.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp MSDN Library - http://msdn.microsoft.com/library/default.asp

[Chris Hohmann]

"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:%2******** ********@TK2MSF TNGP11.phx.gbl. ..

"Christina" <ha********@hot mail.con> wrote in message
news:eN******** ******@TK2MSFTN GP09.phx.gbl...

I have a post-form that holds a listbox with mulitple selected items. When the form is posted to the server ASP file, I want to loop through the selected items, to insert each of them into a table. How do I do that?
If I execute the line:
Response.Write( Request.Form("L istBox")),
I get the list of selected values, separated by commas.
Christina

I believe that the items are probably separated by a comma and a space
actually, yes? What you'd want to do is create an array.

<%
sVal = Request.Form("L istbox")
''sVal = "Joe, Bob, Tom, Phil, Toby" for argument's sake

ArrayOfValues = Split(sVal, ", ")

For i = 0 To UBound(ArrayOfV alues)
Response.Write "Value " & i & " is " & ArrayOfValues(i ) & "<br>"
Next
%>

Ray at work

I believe Request.Form(Ke y) is already an array (sort of):

<%
Dim i,iMax
iMax = Request.Form("t est").Count
For i = 1 To iMax
Response.Write Request.Form("t est")(i) & "<br>"
Next
%>
<form method="post">
<select name="test" multiple="multi ple">
<option value="apple">a pple</option>
<option value="banana"> banana</option>
<option value="cranberr y">cranberry </option>
<option value="danish"> danish</option>
<option value="egg">egg </option>
</select>
<input type="Submit">
</form>

The documentation states as much. However, what is not made clear is
that there is an implicit translation to a string when a form variable
is referenced. As such the following fails with a type mismatch:

UBound(Request. Form("test"))

Here's a link to the documentation:
http://msdn.microsoft.com/library/en...bom_reqocf.asp
HTH
-Chris

[UncleWobbly]

play safe and trim the items in the array as they are used :o)
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:ez******** ******@TK2MSFTN GP11.phx.gbl...

What I'm wondering is if the separator is done by the server or if the
browser chooses the delimiter and posts the data with it. I ~believe~ that the browser submits data like:

select=a&select =b&select=c, etc. and it's the ASP process that returns that as comma+space delimited values.

Ray at work
"Roland Hall" <nobody@nowhere > wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

"UncleWobbl y" wrote:
: of course that should read
:
: myarray=split(R equest.Form("Li stBox"),",")

or:
myarray=split(R equest.Form("Li stBox"),", ")
...if there is actually a space in it as Ray mentioned.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation -

http://msdn.microsoft.com/downloads/list/webdev.asp

MSDN Library - http://msdn.microsoft.com/library/default.asp

[Ray at]

Actually, I think I now prefer the method Chris posted, because if one of
your option values is "B, C" that'll be split. I am so finished with
splitting multi-element form controls! :]

Ray at work

"UncleWobbl y" <he***@talk21.c om> wrote in message
news:40******** *************** @lovejoy.zen.co .uk...

play safe and trim the items in the array as they are used :o)
"Ray at <%=sLocation% >" <myfirstname at lane34 dot com> wrote in message
news:ez******** ******@TK2MSFTN GP11.phx.gbl...

What I'm wondering is if the separator is done by the server or if the
browser chooses the delimiter and posts the data with it. I ~believe~

that

the browser submits data like:

select=a&select =b&select=c, etc. and it's the ASP process that returns

that

as comma+space delimited values.

Ray at work
"Roland Hall" <nobody@nowhere > wrote in message
news:%2******** **********@TK2M SFTNGP09.phx.gb l...

"UncleWobbl y" wrote:
: of course that should read
:
: myarray=split(R equest.Form("Li stBox"),",")

or:
myarray=split(R equest.Form("Li stBox"),", ")
...if there is actually a space in it as Ray mentioned.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of merchantability or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation -

http://msdn.microsoft.com/downloads/list/webdev.asp

MSDN Library - http://msdn.microsoft.com/library/default.asp