[thelist] On Error Resume Next

Peter Brunone (EasyListBox.com) peter at easylistbox.com
Wed May 3 10:11:08 CDT 2006


		Why do you need to use it?  If you must, build your code into a sub and keep it inside the scope of the subroutine.  Writing to a file or database shouldn't be any different from the way you'd do it normally... what's the question here?

Seriously, though, have you considered using GetRows or even GetString to avoid the massive performance hit (and inconvenience) of walking a recordset?

http://learnasp.com/learn/whygetrows.asp

HTH,

Peter

				From: "Rob Smith" rob.smith at lexjet.com

I've been reading up on this idea, yes it's dangerous, but I need to use
it specifically within a while not rs.eof. Do I use it at the top of the
page? In the loop? Where? At the end? And I want to write all errors to
a log file or database table. I haven't found much to answer those
questions yet... Any help is appreciated.

Rob Smith
LexJet
rob.smith at lexjet.com
http://www.lexjet.com
(800)453-9538
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236



More information about the thelist mailing list