p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: Creating functions for opening and closing connections


Message #1 by "Peter Foti (PeterF)" <PeterF@S...> on Tue, 7 Aug 2001 12:09:49 -0400
Trust me, this is _after_ the creative SQL. More could have been done 
using
temp tables and cursors in sp's, but I didn't want to have to sit down 
and
build 2 versions of the page and test them for speed.

regards
David Cameron
nOw.b2b
dcameron@i...

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, 8 August 2001 12:35 PM
To: Pro ASP HowTo
Subject: [proasp_howto] Re: Creating functions for opening and closing
connections


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "David Cameron" <dcameron@i...>
Subject: [proasp_howto] Re: Creating functions for opening and closing
connections


: Agreed, but even so I still need more than one cn in a few pages.
: One of these pages is 500+ lines of straight ASP and uses 7
: recordsets (some opened once for each record returned by another rs).
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Hmm - surely this could be solved with some creative SQL, rather than 
lots
of recordset objects...(I've just seen too many painful cases where 
people
where doing what you are doing...not saying that yours isn't the best 
way,
but it _might_ be possible to get it working better...)

Cheers
Ken


  Return to Index