um, i have not attempted a query yet, i thought i would pose the question before i started.
-----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:55 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) Sorry, my bad. I misinterpreted his question. :( -----Original Message----- From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 1:57 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) Ryan, Yes, I agree with you. You can wrap your query in a stored proc and it may indeed be faster and provide a level of abstraction. But, I sensed that he was saying there was no way to do this in a query - that he would have to write a lengthy case statement or temp table or whatever to accomplish this. I just wanted to point out that there are date functions that can sort out his data for him. -mk -----Original Message----- From: Ryan Pieszak [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 03, 2002 12:42 PM To: CF-Talk Subject: RE: Listing Current Activity (Stored Procedure??) Just my two cents... We've found that SP's are much much quicker than queries. So even if you could do it in a query, you may want to consider a stored proc. At least do some performance testing on both. -----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? ______________________________________________________________________ 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