put rs into an array

[TRACEYMARYLAND]

Not very clued up on arrays but i want to put

ACCESSORIES 38 84.00
CUT & SEW 38 24.00
CUT & SEW 42 600.00



in to an array so that i get
38 42
ACCESSORES 84.00 600.00
CUT & SEW 24.00


FROM WEEK 1 TO WEEK 52

Can it be done...

I just want to them print out array rather easily.

 

[Tarwn]

Err...your reordering of the data doesn't make sense to me...
You moved the 38 and 42 to the top line, put the two 38 names under 38, but then moved the prices around differantly...are the 38 and 42 the week numbers or are those somewhere else?

_{01000111 01101111 01110100 00100000 01000011 01101111 01100110 01100110 01100101 01100101 00111111}
Need an expensive ASP developer in the North Carolina area? Feel free to let me know.

 

[TRACEYMARYLAND]

Yes week number

trying to get it displayed like this in my ASP page
1, 2, 3, 4 etc
resource id 10

 

[EBGreen]

I would recommend a Dictionary of dictionaries the outer dictionary could have members for each week(1-52) and each daughter dictionary could have an element for each category (ACCESSORES, CUT & SEW, etc) with the key being the category name and the number being the number for that week's sales(?) of that product. I can do a specific example with the information you posted if you tell me the structure of the recordset you are reading from.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[TRACEYMARYLAND]

Thats complex...i ended up getting the SQL itself procedure to display the results in the correct format before i got to the ASP page..then i just loop round the records

1 2 3 4
operation

That seems to be working

Thanks

 

[TRACEYMARYLAND]

Actually an example would be great then i know both ways took me a week to do the SQL...when i used to ASP

Recordset is
WorkOrder_Base_ID
Resource_Id
Week_No

So i get 1 2 3
100001
assembly 10 15 16
cut and sew 2 4 3

Thank you

Table ACTUAL_HOURS