Posted by PW on 10/06/07 13:14

One of my ASP's was working fine for a long time. Now it has started
constantly refreshing itself. Everytime I run it I just get the first part
of the page, then it refreshes itself, the rest of the page doesn't get
displatyed, and this goes on continuously.

The main sympton is that the select box thats being populated gets a
different number of rows loaded into it each time. And the last row that
gets loaded is always truncated. Its almost like theres some size
limitation its encountering. I didn't think there was a limit on select
boxes.

The ASP is index.asp, and I have a form that submits it to itself.

Even thought this is an ASP I think the problem could be with the select
(html) box.

Any help is greatly appreciated.

I'm using WinXP Pro SP2, IIS, Access db.

Here's the code segment ...

<form method="GET" action="index.asp">
<input type="submit" value="Ok" style="width:
<%=Session("SystemButtonWidth")%>; height:
<%=Session("SystemButtonheight")%>;">
Q-TAGS SELECTION LIST (red lines indicate notes are attached)
<br>
<SELECT name="lbESCI" size="7"
style="font-size:10;color:BLACK;font-family:ARIAL">
<%
Do While Not rs1.EOF
if len(rs1("NOTES")) > 0 then
myOptionText = " class=red "
else
myOptionText = " class=black "
end if

if mySearchString <> "" then
if rs1("ESCI") = mySearchString then
response.write "<option selected " & myOptionText & ">"
else
response.write "<option " & myOptionText & ">"
end if
elseif rs1("ESCI") = left(myQueryString,6) then
response.write "<option selected " & myOptionText & ">"
else
response.write "<option " & myOptionText & ">"
end if

myOption = rs1("ESCI") & " | " & rs1("ESCN")
response.write myOption
response.write "</option>"
rs1.MoveNext
Loop
%>
</select>
</form>

[Back to original message]