I wouldn't use cfschedule for this. It sounds like what you are asking for is akin to store hours. In other words, between 1/1/2006 and 2/28/2006 you want the "store" to be open between the hours of 9am and 5pm. And you want it to be possible that you can have appropriate users set these date ranges in some sort of admin area. Is this correct? If so, what you need to do is simply run a check against this data, so that if right now is not within one of these date ranges you cannot access the area. Consider this to be a sort of security system much like you would use for a login area. If you have these values in a database you can query against them like this: <cfquery name="MyQueryName" datasource="MyDSN"> SELECT * FROM MyTable WHERE DateStart <= #CreateODBCDateTime(Now())# AND DateEnd >= #CreateODBCDateTime(Now())# </cfquery> If your recordcount is 0, then the "Store" is closed and you should deny access to the protected area. You can accomplish this by placing a <cflocation> tag at the top of the page like this <cfif MyQueryName.RecordCount EQ 0> <cflocation url="home.cfm" addtoken="yes"> </cfif> Hope that is helpful On 10/25/05, Roberto Perez <[EMAIL PROTECTED]> wrote: > > At 01:17 AM 10/26/2005, Jenny wrote: > > >I think this is what you need ... > > > >http://livedocs.macromedia.com/coldfusion/6/CFML_Reference/Tags-pt229.htm > > > >cfschedule .. > > > Thanks for your answer. I'm not familiar with the CFSchedule tag, so I'll > read more about it. In the meantime, let me ask you: > > - can the 'startDate = "date" ' and 'startTime = "time" ' attributes be > read from a database (as the one I have now with "date" and "time" > values")? > > - can one of the actions be an "update" to a database (so that the field > "status" in the database is changed from "closed" to "open")? > > > Thanks in advance, > > Roberto Perez > [EMAIL PROTECTED] > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:222261 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
