No that's not it, 0 translates to false in CF. So if myQuery.recordcount is 0, then <cfif myQuery.recordcount> would return false.
My suspicion is that you have somewhere in your code a <cfsetting enablecfoutputonly="yes">. Is the code you posted earlier the actual code, or is it just an example? Becaus if you have <cfoutput> tags after the cfif, it would output what is between them, but if after the cfelse you don't have <cfoutput> tags, it would leave it blank (with the enablecfoutputonly setting on.) Mingo. alex poyaoan wrote: > got your point about that so even if the result is zero it is still true so > what's the alternative i could do so that when it is zero it prints a message ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258247 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4