"Mark" wrote:
> The global.asa and other ‘wizards’ are part of Visual Interdev. Have never used (or even seen) it. (Been writing ASP code for 9 years &
spent 3 years at MS in VB.NET group...so you can see how popular it is, even
at MS.)
> I don’t want to be limited with record set size. You aren't. Recordsets are always limited only by the number of records
available from the DB.
Dunno where you got any other impression.
Even when you do paging, as I showed you, and do something like
RS.AbsolutePosition = 189 ' moves to the 189th record
you can *still* do
Do Until RS.EOF
... process one record ...
RS.MoveNext
Loop
and if there are 13,481 records in that database query, you'll go to the
13,481st of them!
You can do some "tricks" in ADO to restrict the number of records grabbed in
one transfer (e.g., RS.MaxRecords = 17) but even that is overridable.
Now, if you really only want one record at a time (as you seemed to imply
when you wrote:
a stored procedure which brings only the
desired record is where I’m headed
I'm not even sure why you are worried about "recordset size".
SO... If there are limitations in that scripting object model that you
don't like, just don't use it. I'm sure 90% or more of what it is doing can
be duplicated with a couple of lines of HTML code and a few lines of VBScript.
************
You are going to hate me for saying this, but...
You are really wasting your time learning ASP. ASP is obsolescent and
rapidly dying. One popular ASP forum that used to get 250 to 300 posts per
day is down to maybe 10 a day. Very few companies are doing original work in
ASP.
I really feel that if you are trying to learn the Web and trying to learn
new technology that you should abandon ASP and move to ASP.NET. The tools
are many times better and the online documentation (and especially tutorials)
are so much better that it's hard to find words to describe the differences.
I really would STRONGLY suggest that you visit
http://msdn.microsoft.com/Express
and start by downloading the Visual Web Developer Express pacakage. And
then just explore around on that site and on
http://www.asp.net and you will
be overwhelmed with wonderful learning materials.
Still, if you are determined to learn ASP, there are a bunch of us obsolete
old-timers around.
Maybe I must? But without
> using the above mentioned method to avoid record set size, a stored procedure
> which brings only the desired record is where I’m headed. This investigation
> will eventually lead to ‘ownership’ of some complex asp pages which at this
> point seem a bit overwhelming. I’m just trying to get my footing. Teachers
> such as yourself are indispensable.
> Thank you.
> Mark
>