Two thoughts here ... - What precisely was the generated SQL? You'd need to print it and have a look at it. I would suspect that it inadvertently became quite legal syntax.
- Is your code set up to deal with an empty record set? In fact, did the database engine ever return a record set? It could have got stuck trying to process the SQL and crashed the server there. Is the database big? Maybe it selected every record in the database and got into trouble trying to return a humungous record set. As a first instance, switch on your SQL print statement and switch off your SQL execute statement. This will at least ensure you can see the actual SQL without crashing the server. Print it out and I think you'll find it instructive. By all means, post that result, plus your code, here, if you'd like us to have a look at it. Dave S ----- Original Message ----- From: GLSmyth To: [email protected] Sent: Wednesday, April 06, 2005 12:36 AM Subject: Re: [ASP] Apparent Looping Problerm 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 [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/
