Hi, thanks so much for everybody's help. I went ahead about put this in a schedule task. just took the code made a separate file, create a task to call that file and used cfinclude to put the file in the index page. I was thinking that it would be good not to use cfschedule as this adds another layer of complexity (unless I am mis understanding cfschedule), so I thought if there was an easy way to do this otherwise cool, but in the end I just used cfschedule.
thanks again! Johnny On Dec 5, 2010, at 12:54 AM, Andrew Scott wrote: > > 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:5162 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
