Thanks Dave!
Here is your final code:
<cfoutput query="story">
#story.fdd_name#
<cfquery dbtype="query" name="qZipCheck">
SELECT fdcount
FROM zip
WHERE zip.fdd_id = <cfqueryparam value="#story.fdd_id#"
cfsqltype="cf_sql_integer">
</cfquery>
<cfif #qZipCheck.fdcount# GT 0>
(#NumberFormat(qZipCheck.fdcount)#)
</cfif>
<br>
</cfoutput>
Awesome.
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:330775
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
