Getting option's text value

Raul · Apr 10, 2007

Hi,

I have a select list that gets populated from the DB. When the user
makes a selection I am able to retrieve this value via
Request.Form(...)

However, I am wondering if you can retrieve the text value using ASP??
I know this can be done in JavaScript using the options text
attribute, but it is possible in ASP?

Any input would be appreciated....Thanks!

Adrienne Boswell · Apr 10, 2007

Raul wote:

Hi,

I have a select list that gets populated from the DB. When the user
makes a selection I am able to retrieve this value via
Request.Form(...)

However, I am wondering if you can retrieve the text value using ASP??
I know this can be done in JavaScript using the options text
attribute, but it is possible in ASP?

Any input would be appreciated....Thanks!

You could append the value to the option value, eg: <option value="<
%=rsarr(0,i)%>:<%=rsarr(1,i)%>"><%=rsarr(1,i)%></option>

Then when you get the values
things = split(request.form("that"),":")
optionvalue = things(0)
textvalue = things(1)

vinodkus · Apr 11, 2007

Hi,

I have a select list that gets populated from the DB. When the user
makes a selection I am able to retrieve this value via
Request.Form(...)

However, I am wondering if you can retrieve the text value using ASP??
I know this can be done in JavaScript using the options text
attribute, but it is possible in ASP?

Any input would be appreciated....Thanks!

select.asp
<body>
<form name = form1 method = post action = "PrintSelectList.asp">
<select name = "cboToppings" size = 4 multiple>
<option selected>Cheese
<option selected>Totmato Sauce
<option>Olive Oil
<option>Barbecue Sauce
<option>Pepperoni
<option>Sausage
<option>Mushrooms
<option>Onions
<option>Ham
<option>Pineapple
<option>Green Peppers
<option>Anchovies
</select>
<p>
<input type = submit name = cmdSubmit value = "Deliver It">
</p>
</form>
</body>

PrintSelectList.asp
<body>
<%
dim strSelect
dim i
strSelect = split(Request.Form("cboToppings"), ", ")
length = len(str)
for i = 0 to UBound(strSelect)
response.write strSelect(i) & " "
next
%>
</body>

Raul · Apr 13, 2007

select.asp
<body>
<form name = form1 method = post action = "PrintSelectList.asp">
<select name = "cboToppings" size = 4 multiple>
<option selected>Cheese
<option selected>Totmato Sauce
<option>Olive Oil
<option>Barbecue Sauce
<option>Pepperoni
<option>Sausage
<option>Mushrooms
<option>Onions
<option>Ham
<option>Pineapple
<option>Green Peppers
<option>Anchovies
</select>
<p>
<input type = submit name = cmdSubmit value = "Deliver It">
</p>
</form>
</body>

PrintSelectList.asp
<body>
<%
dim strSelect
dim i
strSelect = split(Request.Form("cboToppings"), ", ")
length = len(str)
for i = 0 to UBound(strSelect)
response.write strSelect(i) & " "
next
%>
</body>

Thanks for the input everyone. In the meantime I thought of a
solution that nobody else posted on here...I personally like it more.
Add an onclick event to the option element. Whenever it gets clicked,
save the text into a hidden form field. This value can then be used
as you like (I needed it to save the user input to the DB)

Cheers!

Bob Barrows [MVP] · Apr 13, 2007

Raul said:
Thanks for the input everyone. In the meantime I thought of a
solution that nobody else posted on here...I personally like it more.
Add an onclick event to the option element. Whenever it gets clicked,
save the text into a hidden form field. This value can then be used
as you like (I needed it to save the user input to the DB)

Sure, that's one of the ways to do this, but why do you like it better?
Now you're at the mercy of a user who can easily disable javascript in
his browser.

Raul · Apr 13, 2007

Sure, that's one of the ways to do this, but why do you like it better?
Now you're at the mercy of a user who can easily disable javascript in
his browser.

Good point on that one, but I know all our users dont have JavaScript
disabled (its not a public site). If they had JavaScript disabled
then the site will not function properly.

To answer your question, I like it better because it seems more
elonquent than adding a delimiter to the value and appending the
description. Its just my opinion obviously, it is largely a stylistic
choice. Does anyone agree or am I on my own on this one?

Dave Anderson · Apr 13, 2007

Raul said:
Thanks for the input everyone. In the meantime I thought of a
solution that nobody else posted on here...I personally like it
more. Add an onclick event to the option element. Whenever it
gets clicked, save the text into a hidden form field. This
value can then be used as you like (I needed it to save the
user input to the DB)

I fail to see how that is an improvement over getting the value from the
database. The advantage of direct DB query is especially acute if the table
you are updating is in the same database as the one you are filling options
from, since you can simply do it in the DB at insert.

Dave Anderson · Apr 13, 2007

Raul said:
Good point on that one, but I know all our users dont have
JavaScript disabled (its not a public site). If they had
JavaScript disabled then the site will not function properly.

You are making far too many assumptions. I, for one, run the NoScript
extension when I browse the web. With it, I can temporarily turn on
scripting for a site, get past the non-working stuff, and turn it back off.
How exactly do you think you could circumvent that?

I don't even know where to begin with the Web Developer extension. There is
almost nothing you can do client-side to prevent me from controlling the
content of my requests. You should, therefore, concentrate on handling
requests, not dictating them.

To answer your question, I like it better because it seems more
elonquent than adding a delimiter to the value and appending
the description.

In the sense that it more explicitly divides the text and value, I agree
that this is a better approach than delimited concatenation. But neither is
robust.

Getting extra blank rows from appending HTML..?	2	Oct 24, 2023
Set value after clicking in field	11	May 9, 2023
Is this right way to convert data attributes values to number in javascipt? Need to get valid numeric value or 0	2	May 30, 2023
Help with a on numeric value encountered warning	2	Mar 6, 2023
Extracting value from nested JSON	2	Sep 10, 2023
Jquery not triggering / acting as expected.	0	Mar 6, 2022
Problem Splitting Text String	2	Dec 29, 2022
Filter table rows based on multiple checkboxes value	2	Jan 13, 2023

Getting option's text value

Raul

Adrienne Boswell

vinodkus

Raul

Bob Barrows [MVP]

Raul

Dave Anderson

Dave Anderson

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads