Always, always, validate a query string before you use it for anything. Anyone could have fudged the URL.
To help with this, I recommend always making your query string in the keyword=value&keyword2=value2&... style. If the required keywords aren't there, you know you have an invalid call. Dave S ----- Original Message ----- From: GLSmyth To: [email protected] Sent: Tuesday, April 05, 2005 10:48 PM 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 --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [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/
