queryColumnExists

Checks whether a column exists in the given query object

queryColumnExists(query, column) → returns boolean

Member Function Syntax

query.columnExists(column)

  1. CFDocs
  2. Functions
  3. Query Manipulation Functions
  4. queryColumnExists
  5. Lucee
  6. BL 1.0.0+
  7. 0 Issue
  8. Edit
See Also:   queryColumnList   queryColumnCount   queryColumnArray   valueArray

Argument Reference

query query
Required

column string
Required

Examples
Sample code invoking the queryColumnExists function 

myQuery = queryNew("ID,name,age");
writeOutput(queryColumnExists(myQuery,"ID"));

Expected Result: true

myQuery = queryNew("ID,name,age");
writeOutput(queryColumnExists(myQuery,"gender"));

Expected Result: false

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

Fork me on GitHub