|
 |
asptoday_discuss thread: Any Way Around the Ordinal in GetRows
Message #1 by howard@c... on Tue, 18 Dec 2001 02:24:31
|
|
I have inheirited a web site that uses the DoWhile...MoveNext
methodology. Currently it requires many recordsets. I am wanting to (at
the least) to GetRows.
Problem:
Having trouble convincing the powers that be to use because of the need
access data through array(n,n) i.e. The ordinal in loops, etc. as opposed
to the rs("FieldName") in recordset.
Could I get some feedback as to the necessity of GetRows over MoveNext
EVEN though you don't have descriptive display names.
Thanx in advance...
Howard@R...
P.S. This particular page uses 19 recordsets. When I first got it, there
were no .Closes or Set Nothings...
Message #2 by Aaron Bull <aaronb@a...> on Tue, 18 Dec 2001 13:37:36 +1100
|
|
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C1876C.F42427F4
Content-Type: text/plain
19 recordsets ???
Time to look at some stored procedures maybe...
Aaron
-----Original Message-----
From: howard@c... [mailto:howard@c...]
Sent: Tuesday, 18 December 2001 1:25 PM
To: ASPToday Discuss
Subject: [asptoday_discuss] Any Way Around the Ordinal in GetRows
I have inheirited a web site that uses the DoWhile...MoveNext
methodology. Currently it requires many recordsets. I am wanting to (at
the least) to GetRows.
Problem:
Having trouble convincing the powers that be to use because of the need
access data through array(n,n) i.e. The ordinal in loops, etc. as opposed
to the rs("FieldName") in recordset.
Could I get some feedback as to the necessity of GetRows over MoveNext
EVEN though you don't have descriptive display names.
Thanx in advance...
Howard@R...
P.S. This particular page uses 19 recordsets. When I first got it, there
were no .Closes or Set Nothings...
Message #3 by howard@c... on Tue, 18 Dec 2001 03:13:06
|
|
I plan to go to stored procedures as quickly as possible...I have just
written a utility and it uses a stored procedure and GetRows...I am
looking for supporting thoughts for the USE of GetRows...I already have
powers into the sp thing...
You need both for optimum speed...
Howard
Message #4 by "Roger M. Taylor" <rogertaylor@f...> on Mon, 17 Dec 2001 22:23:33 -0500
|
|
http://www.learnasp.com/learn/subgetrows.asp
shows two ready made libraries that eliminate ordinal numbers in getrows.
At 02:24 AM 12/18/2001 +0000, you wrote:
>I have inheirited a web site that uses the DoWhile...MoveNext
>methodology. Currently it requires many recordsets. I am wanting to (at
>the least) to GetRows.
>
>Problem:
>
>Having trouble convincing the powers that be to use because of the need
>access data through array(n,n) i.e. The ordinal in loops, etc. as opposed
>to the rs("FieldName") in recordset.
>
>Could I get some feedback as to the necessity of GetRows over MoveNext
>EVEN though you don't have descriptive display names.
>
>Thanx in advance...
>
>Howard@R...
>
>P.S. This particular page uses 19 recordsets. When I first got it, there
>were no .Closes or Set Nothings...
Message #5 by "Patrick" <patrick00@n...> on Tue, 18 Dec 2001 19:12:51 -0000
|
|
I agree with Aaron
19 recordsets???
why loop through a record set. Write your SQL to retrieve all data from the
table which meets the SQL criteria, then use the Do While, rs.MoveNext,
Loop
command
I have written quite a few databases which hold thousands of records and use
this method without any problem
----- Original Message -----
From: <howard@c...>
To: "ASPToday Discuss" <asptoday_discuss@p...>
Sent: Tuesday, December 18, 2001 2:24 AM
Subject: [asptoday_discuss] Any Way Around the Ordinal in GetRows
> I have inheirited a web site that uses the DoWhile...MoveNext
> methodology. Currently it requires many recordsets. I am wanting to (at
> the least) to GetRows.
>
> Problem:
>
> Having trouble convincing the powers that be to use because of the need
> access data through array(n,n) i.e. The ordinal in loops, etc. as opposed
> to the rs("FieldName") in recordset.
>
> Could I get some feedback as to the necessity of GetRows over MoveNext
> EVEN though you don't have descriptive display names.
>
> Thanx in advance...
>
> Howard@R...
>
> P.S. This particular page uses 19 recordsets. When I first got it, there
> were no .Closes or Set Nothings...
>
>
>
|
|
|
View Cart
