cfdocs

queryKeyExists

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

queryKeyExists(query, key)

returns boolean

Member Function Syntax

query.keyExists(key)

Argument Reference

Name	Type	Required	Default	Description
query	query	Yes		Query Object to test.
key	string	Yes		Key to test

Check to see if column exists in Query

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: YES

This site is open source. Improve this page.