[thelist] Bad DB Data?

Adam Slesinger badlanners at hotmail.com
Mon Dec 2 10:19:01 CST 2002


Hi folks.  The SQL newbie has a few more questions if you don't mind...

I'm just starting to work on an emailer script for a newsletter and am in
the testing phase.  An ASP goes through the DB and sends the newsletter to
the e-mail of that record, and then updates a field in that record to
indicate that the e-mail was sent.  The script only does 500 emails at a
time.  In testing, the script works for all of the email groups except two
of them where I get this message:

Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/newsletter/emailer.asp, line 44

The DB was populated with an excel spreadsheet with lots of yucky stuff in
it.  Backslashes, forwardslashes, quotes, and semiquotes - several of these
in the e-mail fields.  I took out these 4 characters in the e-mail field
entries.

I have <% server.scripttimeout = 10000 %> set, and again, it works for all
of the other blocks except two. I'm assuming there is still some bad data in
the database that is causing this timeout.

Can ayone shed any light?

Thanks much!

adam



More information about the thelist mailing list