[thelist] ColdFusion MX and CFIF notation
Scott Brady
evolt at scottbrady.net
Wed Nov 20 16:10:01 CST 2002
>Under ColdFusion MX, no matter what query.RecordCount is: 0, 1, 42, 20
>billion, <CFIF query.RecordCount> always returns true as long as the query
>is called.
What is the query you're checking? If it's a query that returns an aggregate value (such as COUNT(*)), then even if there aren't any records, the query still returns a record with that value = 0, so your if statement would be TRUE in that case.
Scott
More information about the thelist
mailing list