cfdocs

queryColumnExists

Checks whether a column exists in the given query object

queryColumnExists(query, column)

returns boolean

Member Function Syntax

query.columnExists(column)

Argument Reference

Name	Type	Required	Default	Description
query	query	Yes
column	string	Yes

ID column is in given query

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

Expected Result: YES

Whereas “gender” is not

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

Expected Result: NO

This site is open source. Improve this page.