HI below is the structure of the db table and yes also instances from one year to the other
columnname datatype allownulls EventID int Unchecked StartDate datetime Checked EndDate datetime Checked EventInfo nvarchar(255) Checked Type int Checked >do you store the event's end month or full date or duration in the db, >too? what are the fields? >how about events that start in one year and end in the next??? > >post your db table structure (with data types and explanations of what >data is stored in the filed if not clear from filed name). > >Azadi Saryev >Sabai-dee.com >http://www.sabai-dee.com/ > > > >alex poyaoan wrote: >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315270 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

