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/
