I've got a query that returns a date and a sales figures for the previous
365 days. I need to write this information to a report in the format of:
Jan 1 Feb 1 Mar 1 Apr 1 May 1 ...
Jan 2 Feb 2 Mar 2 Apr 2 May 2 ...
Jan 3 Feb 3 Mar 3 Apr 3 May 3 ...
Jan 4 Feb 4 Mar 4 Apr 4 May 4 ...
On to the end of the days in the month.
>From an architectural stand point, what is the best way to do this?
Paul
This message and any attachments may be confidential or privileged and are
for the exclusive use of the intended recipient. If you are not the
addressee or intended recipient, please do not read, copy, use, or disclose
this communication to others. If you have received this in error, please
notify the sender by replying to this message, and then delete it entirely
from your system. Delivery of this message and any attachments to any
person other than the intended recipient(s) is not intended in any way to
waive confidentiality or a privilege. All personal messages express views
only of the sender, which are not to be attributed to Finish Line, and may
not be copied or distributed without this statement.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
