Using LIMIT and OFFSET Query of Queries

[riteshl80338356]

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]

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,

^ _ ^