Page continuously refreshes

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 ...

Re: Page continuously refreshes

The rs1 sql query is here ...

mySQL = mySQL & "SELECT DISTINCT Qtags.ESCI, Qtags.ESCN, Notes.Notes "
mySQL = mySQL & "FROM QTags LEFT JOIN Notes ON (QTags.ESCI = Notes.ESCI) "
mySQL = mySQL & "ORDER BY Qtags.ESCI "
rs1.open mySQL,myDSN

Re: Page continuously refreshes

Heres some new info I just discovered.

I changed one line of code ...

myOption = rs1("ESCI") & " | " & rs1("ESCN")
to
myOption = rs1("ESCI") & " | " & left(rs1("ESCN"),20)


and it worked for about 10 tries of navigating around, then it went back to
its old behavior.

Sure seems like some kind of limit is being hit.

Re: Page continuously refreshes

Gazing into my crystal ball I observed "PW"
writing in news:RSLNi.6183$H22.2735@news-server.bigpond.net.au:

> 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.
>

Please don't multipost... answered in
microsoft.public.inetserver.asp.general

--
Adrienne Boswell at Home
Arbpen Web Site Design Services
http://www.cavalcade-of-coding.info
Please respond to the group so others can share