Check if a select box has been selected

[PushCode]

I have a page with multiple select boxes that the user will use to refine the results on the page. The form uses method="post".

How do I make sure a select box has been selected?
Here's an example of a select box:
<select name="category">
<option value="">All</option>
<option value="23">Category Name</option>
</select>

Here's an example of what I'm trying to do in ASP:
If len(Request.Form("category")) > 1 Then
Do This
End If

It's not working. I get a Syntax Error. Any help?

 

[espar]

checkboxes arent included in the request object if they are not checked...

so :
if request("cbox") <> "" then
...

tells you that something was selected.

 

[Tarwn]

What is the syntax error you are receiving? Your code looks fine from here.

 

[PushCode]

I figured it out. I was doing the If Then inside of some SQL query code, and I think I was handling that improperly.

On another note, how do you ensure that on a page refresh, that the selected items in select boxes remain selected.

Say I've got the following dynamic select box:

<select name="selSize" class="frm_select">
	<option value="">[ All ]</option>
	<%
	do until rsSize.eof
	%>
	<OPTION value="<%= rsSize("size_id")%>"><% = rsSize("t_size")%></OPTION>
	<%
	rsSize.movenext
	loop
	set rsSize = nothing
	%>
</select>

How do I maintain the selected state of whichever option is selected? Thanks!

 

[Chopstik]

You can just do an if/then statement to append the selected property of your options. Going from memory here, so this may need to be modified.

<select name="selSize" class="frm_select">
    <option value="">[ All ]</option>
    <%
    do until rsSize.eof
    %>
    <OPTION [COLOR=red]<% if request.form("category") = rsSize("size_id") then %>selected<% end if %>[/color] value="<%= rsSize("size_id")%>"><% = rsSize("t_size")%></OPTION>
    <%
    rsSize.movenext
    loop
    set rsSize = nothing
    %>
</select>

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[PushCode]

I tried your suggestion but it doesn't seem to be working.
No errors or anything, id just displays the default(first) [ All ] option.
Here's what I have:

<select name="selSize" class="frm_select">
			<option value="">[ All ]</option>
			<%
			do until rsSize.eof
			%>
			<OPTION<% if request.form("selSize") = rsSize("size_id") then %>selected<% end if %> value="<%= rsSize("size_id")%>"><% = rsSize("t_size")%></OPTION>
			<%
			rsSize.movenext
			loop
			set rsSize = nothing
			%>
		  </select>

 

[Chopstik]

Do a response.write of your request.form("selSize") variable and then compare that to what is in your DB for the "size_id" value. If they're different, then your problem is solved by making sure you get the right variable. Otherwise, check your syntax (I did mention that you may need to modify it as I was going from memory).

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[PushCode]

I did a response.write of request.form("selSize") and it is the correct number.

Can anyone see why this isn't working?

 

[Chopstik]

It's probably just a syntax issue. Try to put a space between Option and Selected.

<OPTION<% if request.form("selSize") = rsSize("size_id") then %> selected <% end if %> value="<%= rsSize("size_id")%>"><% = rsSize("t_size")%></OPTION>

------------------------------------------------------------------------------------------------------------------------
"Men occasionally stumble over the truth, but most of them pick themselves up and hurry off as if nothing ever happened."
- Winston Churchill

 

[PushCode]

I had already noticed and tried that to no avail. Any other ideas?