[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?




				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
rob.smith at lexjet.com
(941)330-1210 Int'l
(941)330-1220 Fax
1680 Fruitville Road, 3rd Floor
Sarasota, FL 34236

More information about the thelist mailing list