Ask a Question related to Macromedia ColdFusion, Design and Development.
-
TheGrezyWeasel #1
Using Maxrows with Nested Output
This seems so simple but how does MAXROWS work with nested queries that are
grouped? If you apply it at the top level it limits the number of groups, not
the number of records. If you apply it at the inner level, it seems to do
nothing. Is there a way to output just a finite number of records (not groups)
without rewriting the code to using CFLOOP or something (which would be hard).
TheGrezyWeasel Guest
-
cfquery with maxrows supposed to be faster?
The query speed will not be affected. The page will load more quickly though, if you are displaying only 10 rows of data rather than 50. How long... -
Nested Group Output
I am attempting to set up a 3 tier category structure for a product catalogue. i.e there sould be a parent category - Cars, then a subcategory -... -
CFQUERY and maxrows attribute
ok, maybe I'm on some bad crack today, but I recall that the maxrows attribute of cfquery works AFTER the resultset is returned to CF from the DB. ... -
CFGRID ? maxRows
I agree with ArtNirvana. If you have maxRows then is reasonable to have page navigation and also you can think about record locator based on sort... -
Dynamic Images in Nested Output
I found an almost answer in the post titled 'dynamic images with information' but I'm using a join to get the records and nested <cfoutput> tags to...
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
