ormExecuteQuery

Runs the HQL on the default data source specified for the application.

ormExecuteQuery(hql, params [,unique]); ormExecuteQuery(hql, [,unique] [, queryoptions]); ormExecuteQuery(hql, params [,unique] [,queryOptions]) → returns any

  1. CFDocs
  2. Functions
  3. ColdFusion 9 New Functions and Tags
  4. ormExecuteQuery
  5. CF9+
  6. Lucee
  7. 0 Issue
  8. Edit

Argument Reference

hql string
Required

A HQL query statement

params any

A struct or array of query params.

unique boolean

If true returns a single entity instead of an array.

queryoptions string

A struct with possible keys: ignorecase, maxResults, offset, cacheable, timeout, datasource

Links more information about ormExecuteQuery

Examples
Sample code invoking the ormExecuteQuery function

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

Fork me on GitHub