query of queries limit issue

[lucidtech]

Whenever I run a query of a query and use 'LIMIT' I get an error. I know cfquery has a maxrows setting but I need to start a certain row as well and limit the results to 10 rows.

 

[cfSearching]

In memory QoQ's do not support LIMIT. So you will need to find another way to limit the rows. Either in your original database query, or within CF code (using cfoutput, etcetera ..).

----------------------------------

http://cfsearching.blogspot.com/

 

[LyndonOHRC]

Have you tried using Top 10? I don't know if it will work as QofQ doesn't use all the standard sql terms.

Share your query, I can think of several ways to use maxrows or Top 10 to get the result set you want but it would be much easier to see your code.

Lyndon

---People Remember about 10% of what you say ---They never forget how you made them feel. Covey

 

[r937]

Have you tried using Top 10? I don't know if it will work as QofQ doesn't use all the standard sql terms.

that won't work in QofQ


also, TOP is ~not~ standard SQL



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[cfSearching]

Yes, QoQ's are _extremely_ limited. Aside from CAST, the documentation only lists two (2) supported functions: UPPER() and LOWER().

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_7.html

----------------------------------

http://cfsearching.blogspot.com/