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
|
The hql query to execute |
paramsOrUnique
any,
optional
|
Alias: params |
uniqueOrQueryOptions
any,
optional
|
Alias: unique |
queryOptions
any,
optional
|
Examples
Simple Examples
res = ormExecuteQuery(
"SELECT id, A FROM test WHERE id = :A AND A = :B"
,{A:"test", B:"aaaa"}
)
See also
- ORM
- Search Issue Tracker
- Search Lucee Test Cases (good for further, detailed examples)