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:5160 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
