VBScript - looping through select options on post back

kittsi · Nov 30, 2012

I have a select options in HTML. On post back I want to loop through this select and get all the values in it. How would I do that in vbscript, I can find anything. I've tried accessing via document.{form}.{select name} but that doesn't work. Any other ideas?

<td align="center">
<select multiple size="15" id="SelectRight">
<option value="one">1
<option value="two">2
</select>

Geates · Nov 30, 2012

document.getElementById("selectRight")
You can use vbs but it will only work in IE. I recommend javascript or PHP. You also need a submit button

Code:

<html>
	<script language="vbscript"> 

		sub doSubmit()
			set objSelect = document.getElementById("selectRight")
			for i = 0 to objSelect.length - 1
				msgbox objSelect.options(i).value
			next
		end sub
	</script>
	
	<body>
		<select id="SelectRight">
			<option value="one">1</option>
			<option value="two">2</option>
		</select>
		
		<input type="button" onClick="doSubmit()" value="submit">
	</body>
[\code]



[URL unfurl="true"]http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm[/URL]

Geates · Nov 30, 2012

correction. object names are case sensitive

set objSelect = document.getElementById("[red]S[/red]electRight")

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

kittsi · Nov 30, 2012

It's not working. Here's what I have (I'm building the select options dynamically). It's not even getting into the procedure ProcessRequest().:

.....

<td align="center">
<select multiple size="15" id="SelectRight">

<%
set rs2 = GenRecordset("SELECT blah blah blah")

If not (rs2.BOF and rs2.EOF) Then
rs2.MoveFirst

Do Until rs2.EOF
%>
<OPTION VALUE="<%response.Write(trim(rs2("column_name")))%>"><%response.Write(trim(rs2("display_name")))%>
<%
rs2.MoveNext
Loop
End If
rs2.Close

%>

</SELECT>
</td>

.....

<input type="button" name="btnSave" id="btnSave" value="Save" onClick="ProcessRequest()" />

.....

'************** Functions ***********************
Sub ProcessRequest()
Response.Write("Here")

Set sel = Document.getElementById("SelectRight")

For i = 0 To sel.length - 1
' MsgBox sel.options.value
Response.Write(sel.options(i).value)
Next

end Sub

guitarzan · Dec 1, 2012

If you are using ASP, you would be better served posting here: forum333

Why not put the code in a form, use <input type="submit" ... />, and use Request.Form to retrieve the selected options?

Geates · Dec 3, 2012

I'm not sure how to appropriately incorporate VBS into ASP (never coded in ASP) but in order for the browser to exeute script, the script needs to be surrounded by <script language="vbscript"> ... code goes here ... </script> tags

-Geates

http://raqxtr.sstar.com/caspdoc/html/chapter_5__developer_s_reference.htm

kittsi · Dec 4, 2012

It is surrounded by vbscript tags and in a form. I tried accessing the elements through Request.Form, that only gives me the option the user selected in the <select><option>, not all the options within the <select>.

I'll try posting in the ASP forum and see if that helps also, was just assuming since I was trying to access it using vbscript that this might be the correct forum.

guitarzan · Dec 4, 2012

was just assuming since I was trying to access it using vbscript

It's a fine line. If what you are doing is specifically vbscript, this is the right forum. But if you are using classic ASP, there are ASP-specific objects (such as the Request Object) that have nothing at all to do with vbscript, and the ASP forum may be of more assistance.

It is surrounded by vbscript tags and in a form.

I don't see any <FORM> tags

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

VBScript - looping through select options on post back

kittsi

Programmer

Geates

Programmer

Geates

Programmer

kittsi

Programmer

guitarzan

Programmer

Geates

Programmer

kittsi

Programmer

guitarzan

Programmer

Similar threads

Part and Inventory Search

Sponsor