Thanks John. Sorry...I want to GROUP the date.
For Example: August 22, 2009 Article 1 Article 2 Article 3 Article 4 August 21, 2009 Article 1 Article 2 Article 3 Article 4 <cfoutput query="articles" group="articledate"> >oh sorry, I miss understood, you want to display data by the date? >if so: ><cfset today = createOdbcdate(now()) /> > ><cfquery name="rs_getArticles" datasource="#your DSN"> >SELECT * >FROM your table >where articledate = #artcledate# >ORDER by articledate > ></cfquery> > >then ><table> ><cfoutput query="rs_dailytip"> ><tr> > <td><b>#DateFormat(articledate, "mmmm d, yyyy")#<br>#artilcetitle#</ >td> ></tr> > ></cfoutput> ></table> > > > >On Aug 23, 2009, at 4:33 PM, Barry Mcconaghey wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:4758 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
