----- Original Message ----- From: S. Isaac Dealey To: CF-Talk Sent: Wednesday, August 14, 2002 2:14 PM Subject: Re: Recurring events in database driven calendar
[snip] Just pray they don't ask you for the ability to schedule events that occur "every third thursday of the month". [/snip] ..exactly why I eventually had data written to the DB at the time of the event building. Many many people do things on the "Fourth Wednesday of the Month" model. It's when business practices clash with programming practices. [snip] You might run into problems with the first weekly event needing to be on the first week of the month in order to prevent gaps at the beginning of following months... ahh well... dates have always frustrated me in SQL Server... [/snip] I'd agree. I find Oracle to be much better at handling this sort of thing. Dates and times are handled very clumsily in SQL Server, esp. with the limited date/time formatting model. ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
