I posted this earlier but did nto see it show up on the list. If it double
posts I apoligize:
Hello list. I have a query that is getting a total of records for a previous
week and I am displaying the total number of records. Now, the customer wants
me to output it into a one week format with a breakdown of the data in each
cell.
The query looks like so:
<cfquery datasource="#application.datasource#" name="getAddMoreCashLead">
SELECT COUNT(LeadDistributionID) AS totalLeadRec
FROM LeadDistribution
WHERE (HttpReferer IS NOT NULL AND HttpReferer IN
('www.addmorecash.com'))
AND DateInserted > '#dPreviousWeek#' AND
DateInserted < '#dToday#'
</cfquery>
I am thinking that I need to put the query in a loop and then create an array
to hold the data or something like that? Or am I complicating this? I am also
putting the result into a CFMAIL tag to email the report weekly to the user. I
admit that since I have not been using CF for the last couple of years due to
my deployment to Iraq and returning to find my old job switched to .NET and
thus had to learn that I am a bit rusty.
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241586
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
