queryIsEmpty

Returns YES if a query has no rows, and NO otherwise. Equivalent to checking query.recordCount == 0.

queryIsEmpty(query) → returns boolean

This function requires Adobe ColdFusion 2025 and up.  Not supported on Lucee, etc.
  1. CFDocs
  2. Functions
  3. ColdFusion 2025 New Functions and Tags
  4. queryIsEmpty
  5. CF2025+
  6. 0 Issue
  7. Edit
See Also:   queryrecordcount   querynew

Argument Reference

query query
Required

The query to check.

Examples
Sample code invoking the queryIsEmpty function

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub