queryKeyExists

Determines whether the specified column (key) is present in a query.

queryKeyExists(query, key) → returns boolean

Member Function Syntax

query.keyExists(key)

  1. CFDocs
  2. Functions
  3. ColdFusion 2016 New Functions and Tags
  4. queryKeyExists
  5. CF2016+
  6. Lucee5.1+
  7. 0 Issue
  8. Edit
See Also:   QuerySort   QueryFilter   QueryEach

Argument Reference

query query
Required

Query Object to test.

key string
Required

Key to test

Examples
Sample code invoking the queryKeyExists function

Uses the member function syntax

news = queryNew("id,title",
    "integer,varchar",
    [ {"id":1,"title":"Dewey defeats Truman"}, {"id":2,"title":"Man walks on Moon"} ]);
writeOutput(news.keyExists("title"));

Expected Result: true

Fork me on GitHub