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? ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.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