You could just put a "featured" bit-field in the table then call a page via scheduled task to set a random one to "featured". Ken
-----Original Message----- From: Che Vilnonis [mailto:[EMAIL PROTECTED]] Sent: Monday, September 23, 2002 11:39 AM To: CF-Talk Subject: Random Product, with a twist? What would be the easiest way to display one random product pulled from a database every 24 hours without session or client variables? Each page refresh would deliver the same content for a 24 hour period. Could this be done based on the "applicationtimeout" setting from the <cfapplication> tag? My default timeout is 24 hours. (applicationtimeout="#CreateTimeSpan(1,0,0,0)#") TIA...Ché ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.