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: > >> <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:4755 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
