1054133 Saturday 5 7/5/2008 4:20:12 AM
1054134 Saturday 5 7/5/2008 5:49:26 AM
1054135 Saturday 5 7/5/2008 5:50:27 AM
1054137 Saturday 5 7/5/2008 5:20:16 AM
1054138 Saturday 5 7/5/2008 5:31:06 AM
1054139 Saturday 5 7/5/2008 5:58:52 AM
1054140 Saturday 5 7/5/2008 7:07:39 AM
1054141 Saturday 5 7/5/2008 7:07:42 AM
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!
