Highlighting V alues in a Drop Down Box - Database

[Bipasha]

This is the code I have to display a drop down box with values from 1 to 100

<select name=&quot;reports&quot;>
<option selected value=&quot;1&quot;>1</option>
<% for i = 2 to 100 %>
<option value=&quot;<%=i%>&quot;><%=i%></option>
<% next
i = i + 1
%>

Suppose I insert (value=45) for reports into a database. The next time I view this drop down box for that particular report....I want 45 to be selected (highlighted) instead of 1 (which is the default)

I tried doing this:
------------------
<select name=&quot;reports&quot;>
<% for i = 1 to 100 %>
If Session(&quot;val&quot = i then
<option selected value=&quot;<%=Session(&quot;val&quot%>&quot;><%
=Session(&quot;val&quot%></option>
<% Else %>
<option value=&quot;<%=i%>&quot;><%=i%></option>
<% End If
next
i = i + 1
%>

Can somebody help me with this problem??

 

[Bipasha]

I tried a lot of methods, but nothing seems to be working. Could anyone please help me with this.

 

[ChrisQuick]

Your:

If Session(&quot;val&quot = i then

is not inside <% %> [sig][/sig]

 

[Bipasha]

Hi Chris,

That was a typing mistake....although in my program that statement is enclosed by <% %>.