tariqews
tariqews

Reputation: 19

ColdFusion ORMExecuteQuerygetting last record

I have a query in mysql below

SELECT newsletterKey 
FROM tblnewsletter
ORDER BY newsletterKey DESC
LIMIT 1

Now when i am use above query in ORMExecuteQuery like

ORMExecuteQuery("FROM Newsletter ORDER BY newsletterKey DESC LIMIT 1");

It display me all records instead of last record

Upvotes: 0

Views: 219

Answers (1)

Henry
Henry

Reputation: 32915

LIMIT is not supported in HQL that's why.

like you said,

ORMExecuteQuery("FROM Newsletter ORDER BY newsletterKey DESC", false, {maxResults=1})

would work.

Upvotes: 3

Related Questions