I am just getting back to this thread because I got side-tracked. Here is my objective. I have 2 frames A and B. Frame B will contain current month's activity dating from the 1st of the month to the current date. Frame A will contain previous month's activity. I have done something similar using standard queries where I have to go in at the beginning of each month and and change date ranges for the current month and move the just completed month over into an "archived" list. I would really like to know how much of this I can make dynamic in order to save time from having to go through that process every month.
Your suggestions are welcome... Thanks in advance. -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:42 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) James, Stored procs are great - and a great idea, but why for this specific thing? Couldn't you do it in a query? select blah blah..... WHERE month(columname) = month(gedate()) -----Original Message----- From: James Taavon [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:27 PM To: CF-Talk Subject: Listing Current Activity (Stored Procedure??) I believe I need a stored procedure for this, but I thought I would ask anyway. I want to be able to list the current month's activity from the first of the month to the current date. In other words, a live data dump from 1st to current date. Am I correct in guessing stored procedure? ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists