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

Object parameter for the entity

Alias: params

uniqueOrQueryOptions
any, optional

Specifies if the object parameter is unique

Alias: unique

queryOptions
any, optional

Options for the query

Examples

Simple Examples

res = ormExecuteQuery(
        "SELECT id, A FROM test WHERE id = :A AND A = :B"
        ,{A:"test", B:"aaaa"}
        )

See also