Using LIMIT and OFFSET Query of Queries

New Here ,
Oct 03, 2019 Oct 03, 2019

Copy link to clipboard

Copied

Hi, I am not being able to use LIMIT and OFFSET in query of queries. 

queryExecute("SELECT * FROM baseQueryResult(obtained after querying database) WHERE CONDITIONS LIMIT 10 OFFSET 0",{},{dbType="query"}) returns Database exception.

Views

198

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Oct 04, 2019 Oct 04, 2019

Copy link to clipboard

Copied

LATEST

QoQ can be a great thing, but it does not support all standard SQL functions.  CF doesn't understand LIMIT 10 OFFSET; it also cannot do things like modulus or other things that we are used to in standard SQL queries.

 

Here is the help page that explains all that you _can_ do in QoQ: 

https://helpx.adobe.com/coldfusion/developing-applications/accessing-and-using-data/using-query-of-q...

 

HTH,

 

^ _ ^

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines