Help with drop down

**barkerx5** · Jan 2, 2011 15:04

I have some code on a page. I know for a fact that all the variables are pulling the correct information from the recordsets, because I did some basic response.write to see if they were showing up... however, when the drop down is populated, they are not pulling the "selected" up... let me know if anyone can help. It may be due to the Loops that I have...just not sure how to fix it. thanks

<%
While ((Repeat3__numRows <> 0) AND (NOT rsFOOD.EOF))
%>
<%
Dim subtotal
subtotal=FormatNumber(rsFOOD("ITEMPrice"),2)*FormatNumber(rsFOOD("ITEMQuantity"),2)%>
<tr>
<td class="action_view"><select name="INVItem<%=rsFOOD("ITEMID")%>" id="INVItem<%=rsFOOD("ITEMID")%>">
<% Do While Not rsFOOD2.EOF%>
<% Dim SelectValue
SelectValue=rsFOOD("ITEMINVID")
%>
<option value="<%=rsFOOD2("FOODID")%>" <%If SelectValue=rsFOOD2("FOODID") Then%>selected<%End If%>><%=rsFOOD2("FOODName")%></option>
<%rsFOOD2.MoveNext%>
<%Loop%>
<%rsFOOD2.Requery%>
</select></td>

**webber123456** · Jan 2, 2011 22:44

you may want to add some spaces around the word "selected" like

...Then%> selected <%End ....

**barkerx5** · Jan 2, 2011 23:49

Good thought, i tried this, but hasn't worked....Thanks.

**awasson** · Jan 3, 2011 00:31

<%If SelectValue=rsFOOD2("FOODID") Then%>selected = "selected"<%End If%>

**barkerx5** · Jan 3, 2011 06:22

Tried this as well, but no luck.. I think it has to do with the double loop happening, but can't figure out why! Keep them coming and I will keep trying. Thanks

**awasson** · Jan 3, 2011 12:30

Well I just noticed that you are dimensioning your selectvalue variable inside the second loop which should actually throw an error. You should move the dim part outside of the loops and if you can assign the value to it above the loops that would be good as well but might not be possible.

<%
Dim SelectValue
SelectValue=rsFOOD("ITEMINVID")
%>

What does the HTML output of the select list look like? Are you getting any occurrences of selected="selected"?

**barkerx5** · Jan 3, 2011 14:00

Now errors are thrown, and the select value is working inside the loop, because I have set it to be written out above each Dropdown, and it shows up. I am not getting any selects to work properly...
Thanks

**awasson** · Jan 3, 2011 15:22

What does the html for your list look like? I wonder if you are seeing select=selected at all or multiple times.

**barkerx5** · Jan 3, 2011 15:26

No selected shows up anywhere. Everything else works 100%, I am still in testing mode and working on other aspects of the form and page, and it is working 100%. All variables are pulling correctly. I even have the variables being used to name certain parts of the forms, and they are pulling properly after every loop, that is why this is bugging me with it.
thanks

**webber123456** · Jan 3, 2011 22:16

you also have to verify not only that the two values look the same on the screen but that they are also the same type programmatically.

sometimes a number comes through as a string when you expect it to be an integer