Hvordan fjernes tomme værdier fra dropdown
http://www.capitolshop.dk/dk_product.asp?IDproduct=51&Brand=Chocolate&Sex=Woman&Name=2222&Category=Beeniesprøv og se den dropdown med "Vælg størrelse". mit udtræk fra databasen viser kun de størrelser der er på lager, men den viser blanke felter for dem som ikke er.
Hvordan fjerner jeg de blanke fra dropdown ?
Koden:
<select name="select" class="fields">
<option value="">Vælg størrelse</option>
<%
While (NOT rsAvailableSizes.EOF)
%>
<option value="<%=(rsAvailableSizes.Fields.Item("s24").Value)%>"><%=(rsAvailableSizes.Fields.Item("s24").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s26").Value)%>"><%=(rsAvailableSizes.Fields.Item("s26").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s28").Value)%>"><%=(rsAvailableSizes.Fields.Item("s28").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s30").Value)%>"><%=(rsAvailableSizes.Fields.Item("s30").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s32").Value)%>"><%=(rsAvailableSizes.Fields.Item("s32").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s34").Value)%>"><%=(rsAvailableSizes.Fields.Item("s34").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s36").Value)%>"><%=(rsAvailableSizes.Fields.Item("s36").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("s38").Value)%>"><%=(rsAvailableSizes.Fields.Item("s38").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("XS").Value)%>"><%=(rsAvailableSizes.Fields.Item("XS").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("S").Value)%>"><%=(rsAvailableSizes.Fields.Item("S").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("M").Value)%>"><%=(rsAvailableSizes.Fields.Item("M").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("L").Value)%>"><%=(rsAvailableSizes.Fields.Item("L").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("XL").Value)%>"><%=(rsAvailableSizes.Fields.Item("XL").Value)%></option>
<option value="<%=(rsAvailableSizes.Fields.Item("XXL").Value)%>"><%=(rsAvailableSizes.Fields.Item("XXL").Value)%></option>
<%
rsAvailableSizes.MoveNext()
Wend
If (rsAvailableSizes.CursorType > 0) Then
rsAvailableSizes.MoveFirst
Else
rsAvailableSizes.Requery
End If
%>
</select>
