><cfquery name="rs_getArticles" datasource="#your DSN"> >SELECT * >FROM your table >ORDER by articledate > ></cfquery> > >the output it: ><cfoutput query="rs_getArticles"> >#DateFormat(articledate, "mmmm d, yyyy")#<br> >#articleTitle# > ></cfoutput> > >John >On Aug 23, 2009, at 4:09 PM, Barry Mcconaghey wrote: > >> Hi John.
I'm trying group my data. For example: For today the was 5 articles ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4752 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
