John, I'd use some sort of Javasript to hide the content until the specific time you wan the content to appear on the site.
Or you could even us a cfif/cfelse statement that checks for the specific date before running the query. - Joel On Sun, Dec 5, 2010 at 10:08 AM, James Schell <[email protected]> wrote: > > Wouldn't that just be a where clause or a query of query? > > Jim > > -----Original Message----- > From: Andrew Scott [mailto:[email protected]] > Sent: Sunday, December 05, 2010 2:54 AM > To: cf-newbie > Subject: RE: timing a cfquery > > > This seems to be a very strange thing you are trying to do, but you must > have your reason. > > The only real thing you can do is wrap a conditional check around the > cfquery checking that it is greater than 11pm, and I say greater than > because there is no guarantee that the page will be run on that time > without > using the scheduler. > > Regards, > Andrew Scott > http://www.andyscott.id.au/ > > > -----Original Message----- > > From: John Barrett [mailto:[email protected]] > > Sent: Sunday, 5 December 2010 7:16 PM > > To: cf-newbie > > Subject: timing a cfquery > > > > > > Hi, > > > > Is it possible to time a cfquery? that is to display the database > > results > only > > after a certain time. So for example if I wanted my query to be > > displayed > for > > a certain date(which I think I have, but might not be best practice), > > as > well as > > a certain time, lets say 11:00 pm? > > > > I know I could create a scheduled task to run the code, but I was > sondering > > there is a way to do it with the cfquery. Below is my code, > > > > Thank you, > > Johnny > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5161 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
