Query to array?

From the title, it sounds like you have a query, and you need some specific values from it, and are wanting to turn it into an array for processing. If this is what you are wanting, I'd use a query of queries...
For instance, if you have a query, named qry_mine, that has all the data you want, and you want to total up a column, say my_val that is in the query, then you could do that with.
<cfquery name="total_my_val" dbtype="query">
  select sum(my_val) as my_tot from qry_mine
</cfquery>
The total is: <cfoutput>#total_my_val.my_tot#</cfoutput>

If this isn't what you were looking for, I agree with DanielSKim, it would help to have more details.

Ok, I'll add some more details - was so stressed out I guess I wasn't thinking clear ;)

I've got a query that picks up quite a bit of data based on a weekly log. Within this data, there's a date and a value field.

The output gets into a table which works a bit like this:

date
------------
time, value, other
time, value, other

date
------------
time, value, other
time, value, other


Every row actually holds the date field as well, but I get rid of it using some formating, so all of that is a single <cfoutput><table> ... </> </>. Now, I'd like to add a new field next to the date cell which sums the values of the value field in the table for the coresponding date.

Since I want the totalValue before the actual row is processed in the output, I was thinking that I should somehow loop through the records and sum them per date?

The query looks like this:
SELECT     TOP 100 PERCENT CONVERT(varchar(10), dbo.kboard_victims.timestamp, 102) AS killDate, dbo.kboard_victims.killID, dbo.kboard_victims.timestamp, dbo.kboard_victims.victim, dbo.kboard_victims.alliance,
                      dbo.kboard_victims.corp, dbo.kboard_victims.destroyed, dbo.kboard_victims.system, dbo.kboard_involved.finalBlow, dbo.kboard_involved.weapon,
                      dbo.kboard_involved.name AS involvedName, dbo.kboard_involved.alliance AS involvedAlliance, dbo.kboard_involved.corp AS involvedCorp, dbo.kboard_involved.ship AS involvedShip,
                      dbo.kboard_victims.totalValue
FROM         dbo.kboard_victims INNER JOIN
                      dbo.kboard_involved ON dbo.kboard_victims.killID = dbo.kboard_involved.killID
<cfif IsDefined("URL.system")> WHERE (dbo.kboard_victims.system = N'#URL.system#')</cfif>
<cfif IsDefined("URL.victim")> WHERE (dbo.kboard_victims.victim = N'#URL.victim#')
OR (dbo.kboard_involved.name = N'#URL.victim#')</cfif>
ORDER BY dbo.kboard_victims.timestamp DESC, dbo.kboard_victims.killID, dbo.kboard_involved.finalBlow DESC

I've been having network problems and my last post was lost :( I'll try to recreate it again.

If DanielSKim's solution works, you are good to go. I'm worried that you may loose some of the detailed data though. I'm not an expert at sql server though so I'm not positive this is the case.

I would submit that if you want to do an array, you could, just preprocess your query using
<CFLOOP query="yourquery"> and build the array, then output the rows as appropriate. I don't believe this to be the best option though.

I still believe that a query of queries is the right solution.  I'm going to presume that you have an output structure something like
<cfoutput query="yourquery" group="KillDate">
  ---- output your date header/group title information here
 <cfoutput>
   --- output the details here
 </cfoutput>
</cfoutput>

If not that structure, some similar looping mechanism that outputs the group date/header information, then the details.

I would submit that using a query of queries inside the loop, but just before you output the header would give you what you need. Query of queries is quite fast, especially if the return results are not huge. You also don't have to colate information from two queries, it happens automatically.

Something like the below

<cfoutput query="yourquery" group="KillDate">
  <cfquery name="total_my_val" dbtype="query">
        --- adjust where clause/query to be appropriate for your data
    select sum(my_val) as my_tot from qry_mine WHERE killdate='#killdate#'
  </cfquery>
  ---- output your date header/group title information here, including #total_my_val.my_tot#
 <cfoutput>
   --- output the details here
 </cfoutput>
</cfoutput>