[thelist] Re: Bad DB Data?

[Adam Slesinger]

Thanks for the clarification, rudy.  Of course, you were right.  Turns out I
wasn't indexing properly.  I couldn't tell you why the script would timeout
when going through a certain block of records, but with the recordset
sorted, there are no more timeouts.  I had orginally thought bad data was
the continuing culprit because quotes and semi-quotes in the field names
were the first thing causing it to break.  Thank you much.

adam

> i'm sorry, perhaps one has to be biased, like me, but the problem you
> describe is likely how your code is handling the data, rather than the
data
> itself
> infinite loops fall in this category, although i am not suggesting that's
> what's causing your problem
> if the problem is repeatable on a certain few records, you will no doubt
> soon find them
> these records may indeed have what we would call bad data, even after you
> have cleansed them of "backslashes, forwardslashes, quotes, and
semiquotes"
> when you find the culprit records, i'll have a look at your select and
> update queries if you like, although i won't be able to help with your asp
> code