ORMExecuteQuery(hql, namedparams [, unique] [, queryOptions])

Description

This type of ORMExecuteQuery lets you pass named parameters to the query. The placeholder for the parameter must be a name and must start with ":" as in ":age" or ":id". The values to the names must be passed as key-value pairs.In addition, you can specify several options to control the behavior of retrieval using queryOptions:

  • ignorecase: Ignores the case of sort order when you set it to true. Use this option only when you specify the sortorder parameter.

  • maxResults: Specifies the maximum number of objects to be retrieved.

  • offset: Specifies the start index of the resultset from where it has to start the retrieval.

  • cacheable: Whether the result of this query is to be cached in the secondary cache. Default is false.

  • cachename: Name of the cache in secondary cache.

  • timeout: Specifies the timeout value (in seconds) for the query

Note: Maxresults and timeout are used for pagination.

Category

ORM functions

Example

To retrieve employee details of all employees whose reside in USA and are also citizens of USA:

<cfset USEmployees = ORMExecuteQuery("from Employee where country=:country and 
citizenship=:country", {country='USA'})> 
<cfset orderDetail = ORMExecuteQuery("from Orders where OrderID=:orderid and 
ProductID=:productid", {orderid=1, productid=901}, true)>