One possible scenario: 1. New table that stores QuoteID and EffectiveDate - the newest record is the "current" quote. 2. Use DateDiff() to check the date of this item against Now() (based on whatever criteria - day,week,month,year,etc.) 3. If the date of the current quote is past the time limit, grab a new quote and use table from #1 to make sure you don't duplicate the one you used in the past X days or weeks and shove the new QuoteID and EffectiveDate into the table from #1.
There's probably a more clever way, but I wouldn't trust CFSCHEDULE ... I've had many, many problems with that feature in the past. If the scheduler works for you, great, but it's never been consistent for me. Joshua Miller [EMAIL PROTECTED] -----Original Message----- From: Mark Smeets [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 10:53 PM To: CF-Talk Subject: Daily/Weekly Quote Generator Hello everyone, I'm trying to write a daily/weekly quote generator. I've got the code that pulls a random quote from my database however I'm not sure how to go about pulling it out every week or every day. (I'd like to be able to interchange from a week to daily) -------------------------------------- Mark Smeets / stranger0 / ICQ: 1062196 [EMAIL PROTECTED] http://www.prowerks.com/stranger "Life is a series of small victories" - Gene Simmons ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
