ORMExecuteQuery()
Runs the HQL on the default data source specified for the application.
ORMExecuteQuery( hql=string, paramsOrUnique=any, uniqueOrQueryOptions=any, queryOptions=any );
Returns: any
| Argument | Description |
|---|---|
|
hql
string,
required
|
edit
The hql query to execute |
|
paramsOrUnique
any,
optional
|
edit
Object parameter for the entity Alias: params |
|
uniqueOrQueryOptions
any,
optional
|
edit
Specifies if the object parameter is unique Alias: unique |
|
queryOptions
any,
optional
|
edit
Options for the query |
Examples
editSimple Examples
res = ormExecuteQuery(
"SELECT id, A FROM test WHERE id = :A AND A = :B"
,{A:"test", B:"aaaa"}
)
See also
- ORM
- Search Issue Tracker open_in_new
- Search Lucee Test Cases open_in_new (good for further, detailed examples)