Here's the unformatted version:

1107768	Thursday  	20	11/20/2008 11:22:40 AM
1107769	Thursday  	20	11/20/2008 11:22:56 AM
1107771	Thursday  	20	11/20/2008 11:28:07 AM
1107772	est       	-32768	11/20/2008
1107774	Thursday  	20	11/20/2008 11:48:51 AM
1107775	Thursday  	20	11/20/2008 11:50:02 AM
1107776	Thursday  	20	11/20/2008 11:51:28 AM
1107778	Thursday  	20	11/20/2008 11:53:12 AM
1107779	Thursday  	20	11/20/2008 12:01:22 PM

This sample is part of a pair which illustrate the usage of two of the more efficient database display routines. This set of code utilizes the GetString method. The other one is covered in our GetRows Sample.

Both of these routines get their efficiency primarily from getting you disconnected from the database as quickly as possible. This one does it by creating a copy of the data in a string variable. This saves you having to do any looping at all in your ASP code!

Similar efficiencies can be gained in traditional code by disconnecting your recordsets as early as possible, but very few people ever actually do this. These recordset methods facilitate getting you out of your objects and getting them released ASAP. That being said, the components are also simply more efficient then doing the same thing in VBScript, so they'll even beat a disconnected recordset, but I figured I'd mention it for those situations when GetRows or GetString is just too cumbersome to use. For the rest of the time use one of these... they're just as easy (if not easier) and they'll save your server a lot of unneccesary work.

As always... don't let the length of the code discourage you... it's mostly comments!