Click to See Complete Forum and Search --> : form not dispalying results to the screen


janice
12-29-2003, 02:45 PM
Can you please help.
When I run this code, it doesn't do anything.
It doesn't even display an error.
I just get a blank screen and when I right-click on it, I see that the value I am trying to pass to it from a previous page, gets passed to this page but this page doesn't display it on the screen.
This is just a snippet of the code.
Thanks in advance.

<table>
<form name="addressForm">
<tr>
<td align="center" colspan="3">
<%
If RS.EOF Then
Response.Write "No Data Found"
Else
%>
<select name="addressSel" onchange="zoomToSelected()">
<option>Select an address:</option>
<%
While (NOT RS.EOF)
%>
<option value=<%=RS("Record")%>><%=RS("spill_loca")%></option>
<%
RS.Movenext
Wend
myConn.close
set myConn = nothing
set rs = nothing
End If
%>
</select>
</td>
</tr>
</form>
</table>

Gunner
12-29-2003, 11:52 PM
Dont know if this is the problem but try changing this:

<%
While (NOT RS.EOF)
%>
<option value=<%=RS("Record")%>><%=RS("spill_loca")%></option>
<%
RS.Movenext
Wend
myConn.close
set myConn = nothing
set rs = nothing
End If
%>

To this:

<%
Do While NOT RS.EOF
%>
<option value=<%=RS("Record")%>><%=RS("spill_loca")%></option>
<%
RS.Movenext
Loop
myConn.close
set myConn = nothing
set rs = nothing
End If
%>

janice
12-30-2003, 07:50 AM
I have already made that change and that is not the problem.
Thanks for trying, though.