Thanks so much that did it .. It's just so simple but i've complicated myself from my original code..
again thanks >all you need for your desired output is: > ><cfquery ...> >... ></cfquery> > ><cfoutput query="getevents"> >#StartDate#<cfif startdate neq enddate> - #EndDate#</cfif> ></cfoutput> > >however, keep in mind that if your startdate and enddate db fields also >include TIME part, your stratdate will not be equal to enddate even if >date parts are same... >you will need to use your db's date/time functions to select only the >DATE part of these fields and compare/output those. > >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:315187 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
