Re: Is it possible to have an array in a table? (again)
Date: Mon, 31 Aug 2009 21:02:11 -0700 (PDT)
Message-ID: <8444092e-8d95-419c-ba4a-0f992622d666_at_m20g2000vbp.googlegroups.com>
On Aug 22, 4:07 pm, Ramon F Herrera <ra..._at_conexus.net> wrote:
> Can a table contain data arranged in two dimensions, and accessible
> through a pair of integer subscripts?
>
> I can live with 1-dimensional arrays, too.
>
> TIA,
>
> -RFH
Thanks to everyone for their help...
I would like to provide a specific example of what I am trying to accomplish. Let's say I run a circus and every day I get the totals sold in a given week.
Categories are: ticket sales, cotton candy, souvenirs, etc.
My application needs to display the sales like this:
Ticket Sales
8/22/2009: $8492.10 8/15/2009: $9024.31 8/8/2009: $7893.03 8/1/2009: $8945.67
People keep on recommending the SQL paradigm, but the above looks to me like something that must be handled by arrays.
I need to display the 6 most recent weeks and I keep on pushing the most recent sales figures at the top, while I roll down and eventually drop the oldest data. This kind of think MUST be handled with an index, such as week-1 or week-2.
If I followed the relational model, I would need to hardcode records such as:
CURRENT_WEEK
WEEK_MINUS_1
WEEK_MINUS_2
etc.
That would be a nightmare to code.
So, the question is how to implement the records (with arrays?) for a rolling scenario like the above described.
Thanks!
-Ramon Received on Mon Aug 31 2009 - 23:02:11 CDT