All: I have a simple query of query as follow: <cfquery name="myQuery" dbtype="query"> Select count(*) as r_count from myAnotherQuery Where [some where clause] </cfquery>
I want the result to be dislayed as zero If it returns no records, So I use val() function <cfoutput>#val(myQuery.r_count)#</cfoutput>, but it doesn't work; it returns an empty string, not zero when no records are returned. Is there a quick way to detect the null and return 0? Nathan ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356093 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
