Using LIMIT and OFFSET Query of Queries

Question

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.

WolfShade · Answer

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-queries/query-of-queries-user-guide.html

HTH,

^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded