p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

asp_databases thread: Re: Arrays or not?


Message #1 by "the Office of Brent Allen VanderMeide" <ccbbttmm@a...> on Sat, 8 Jun 2002 12:21:37 -0600
I agree with Ken,
There's not enough information for us to troubleshoot and help you.

Thank you,

Brent Allen VanderMeide
Senior Web & Application Developer
brent.vandermeide@s...

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...] 
Sent: Friday, June 07, 2002 1:04 AM
To: ASP Databases
Subject: [asp_databases] Re: Arrays or not?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mcguiness74@h...>
Subject: [asp_databases] Arrays or not?


: A table has been created from the database. Records are
: order by column Amount; DESC.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A table has been created in the database? Or you have a recordset with
records from a table in a database? Where is the table?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: The number of records is variable, because this piece of code is used
: several times. So it might be 15, 12, 6 or even 25.
:
: Want i want to do is to get the data from the first 4 records in 4 new
: variables
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

So you only have 1 column for each record? Or do you have multiple
columns?
If you have multiple columns, how do you want to place the values for
each
field in each record into a single variable?!?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: and all of the remaining records must be counted into the new
: fifth variable.
: I think this must be done with using arrays, but failed up till now.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

What do you mean by "counted"? Do you want to count the number of
remaining
records? Do you want to SUM() a particular column of the remaining
records?
Or something else?

Please reread your original post, and try to be a little bit more exact
in
your specifications. At the moment it is very unclear what you are
doing,
and what you want to do.

Cheers
Ken



Message #2 by mcguiness74@h... on Thu, 6 Jun 2002 18:28:52
Hi,

I need some help on the following:

A table has been created from the database. Records are order by column 
Amount; DESC. 
The number of records is variable, because this piece of code is used 
several times. So it might be 15, 12, 6 or even 25.

Want i want to do is to get the data from the first 4 records in 4 new 
variables and all of the remaining records must be counted into the new 
fifth variable. 
I think this must be done with using arrays, but failed up till now.

Error tells me: subscript out of range.

thanks

Nathan
Message #3 by "Ken Schaefer" <ken@a...> on Fri, 7 Jun 2002 17:03:55 +1000
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <mcguiness74@h...>
Subject: [asp_databases] Arrays or not?


: A table has been created from the database. Records are
: order by column Amount; DESC.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

A table has been created in the database? Or you have a recordset with
records from a table in a database? Where is the table?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: The number of records is variable, because this piece of code is used
: several times. So it might be 15, 12, 6 or even 25.
:
: Want i want to do is to get the data from the first 4 records in 4 new
: variables
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

So you only have 1 column for each record? Or do you have multiple columns?
If you have multiple columns, how do you want to place the values for each
field in each record into a single variable?!?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: and all of the remaining records must be counted into the new
: fifth variable.
: I think this must be done with using arrays, but failed up till now.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

What do you mean by "counted"? Do you want to count the number of remaining
records? Do you want to SUM() a particular column of the remaining records?
Or something else?

Please reread your original post, and try to be a little bit more exact in
your specifications. At the moment it is very unclear what you are doing,
and what you want to do.

Cheers
Ken


  Return to Index