Andy -
The correction was simple, since there are a limited number of columns I just look for them, and if I do not find a match then I redirect the user to another page. My question, however, concerns why this is happening. As far as my logic goes, since there is an errant SQL statement, an error message should be returned, not a recordset. Even if the code is interpreting the error message as a recordset, why is it looping and not ending after the first pass? Cheers - george --- In [email protected], "Mills, Andy R. (Regency)" <[EMAIL PROTECTED]> wrote: > George: > > I am not sure exactly what you are doing: but if you are always expecting a > value in the QueryString: before you do a query on the database: check to > see if that variable has a value: > > sVar = Request.QueryString("Value") > If (Len(Trim(sVar)) > 0) Then > .. > .. > .. Query Database > .. > .. > End If > > It sounds like at the current time, you are not doing this. If the bots / > spyders are always using empty values, this would take care of the problem. > > HTH > Andy > > _____ > > From: GLSmyth [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 05, 2005 8:48 AM > To: [email protected] > Subject: [ASP] Apparent Looping Problerm > > > > I have come across a problem and wonder if anyone can explain why this > might be happening. > > One of my programs uses the value of a query string to determine which > column within a table to obtain its information. What I have come to > learn is that some spiders are accessing the page and not offering a > value in the query string (makes sense). Because of this, the SQL is > trying to get information from a column that does not exist. > > Following the execution of the statement was the standard looping > through the records (yes, I know there is a better way, but it was an > old program). > > What happened was that apparently the code thought that a recordset > had been returned (I would not have thought that that would happen) > and it looped endlessly until it has consumed all memory and the > server crashed. > > I am not understanding why 1.) the code would think that a recordset > was returned, and 2.) why it would continually loop. > > If anyone has any ideas on this then I would greatly appreciate the > education. > > Cheers - > > george > > > > > > --------------------------------------------------------------------- > Home : http://groups.yahoo.com/group/active-server-pages > <http://groups.yahoo.com/group/active-server-pages> > --------------------------------------------------------------------- > Post : [email protected] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > > > > _____ > > Yahoo! Groups Links > > > * To visit your group on the web, go to: > http://groups.yahoo.com/group/active-server-pages/ > <http://groups.yahoo.com/group/active-server-pages/> > > > * To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > > > > * Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service > <http://docs.yahoo.com/info/terms/> . > > > > > [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
