Hi Dave.
Thanks for the code!
Those two did not work.
I got two queries to work perfect but I don't know how to display them.
<!---Get all data--->
<cfquery name="Story" datasource="#request.dsn#">
SELECT F.fdd_id, F.fdd_name, F.fdd_zip, S.statename, S.abrev
FROM fddirectory F, states S
WHERE F.fdd_state = <cfqueryparam value="MD" cfsqltype="CF_SQL_VARCHAR">
AND F.fdd_state = S.abrev
ORDER BY fdd_name
</cfquery>
<!---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:330760
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
