[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