Hi Dave. I fixed the last error message. There was a space here:
name=" qZipTotals " Now the data is displaying but it is not correct. This code below (ZIP)is correct: ><!---Count each fdd_name---> ><cfquery name="Zip" datasource="#request.dsn#"> >SELECT a.zipcode, f.fdd_zip, f.fdd_name, f.fdd_state, count(f.fdd_id) AS >FDCount >FROM articles a, fddirectory f >WHERE a.zipcode = LEFT(f.fdd_zip, 5) > AND f.fdd_state = <cfqueryparam cfsqltype="cf_sql_varchar" >value="MD"> >GROUP BY f.fdd_name >ORDER BY f.fdd_name ASC ></cfquery> > ><!---Display---> ><cfoutput query="zip"> >#fdd_name# >(#NumberFormat(zip.fdcount)# ><br> ></cfoutput> > >This works great but it only displays fdd_name when a.zipcode = >LEFT(f.fdd_zip, 5). > >I would like to display something like this: > ><cfoutput> ><!---Display all fdd_name---> >#story.fdd_name# ><!---Display this if GT '0'---> >(#NumberFormat(zip.fdcount)# ><br> ></cfoutput> > >Thanks for your time. > >Barry ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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-talk/message.cfm/messageid:330766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4