<cf_recordcount>

The actual number of records returned from the query is 800. We have set the output maxrows to 12, which will show 12 records from the table you choose per page. When using the link method, we limit the number of pages in the links to 10. You may set these numbers to whatever you like. For the form button method, you may simply show Previous and Next buttons, or also show a menu of all the pages. We pass 3 test variables, var1, var2, and var3 so you can see the query string being passed. Any variables passed to the tag, using links or form buttons, will be passed along to each page, as form variables when using form buttons, or as URL variables when using links. The level grouped upon is show in red. You may not necessarily need to show results from the levels below that of which you group upon. We show them as an example of how #currentrow# is actually calculated on a grouped output.

	Our CurrentRow	Actual #CurrentRow#
Level 3 Record 1	1	1
--- Level 4 Record 1	1
--- Level 4 Record 2	2
Level 3 Record 2	2	3
--- Level 4 Record 3	3
--- Level 4 Record 4	4
Level 3 Record 3	3	5
--- Level 4 Record 5	5
--- Level 4 Record 6	6
Level 3 Record 4	4	7
--- Level 4 Record 7	7
--- Level 4 Record 8	8
Level 3 Record 5	5	9
--- Level 4 Record 9	9
--- Level 4 Record 10	10
Level 3 Record 6	6	11
--- Level 4 Record 11	11
--- Level 4 Record 12	12
Level 3 Record 7	7	13
--- Level 4 Record 13	13
--- Level 4 Record 14	14
Level 3 Record 8	8	15
--- Level 4 Record 15	15
--- Level 4 Record 16	16
Level 3 Record 9	9	17
--- Level 4 Record 17	17
--- Level 4 Record 18	18
Level 3 Record 10	10	19
--- Level 4 Record 19	19
--- Level 4 Record 20	20
Level 3 Record 11	11	21
--- Level 4 Record 21	21
--- Level 4 Record 22	22
Level 3 Record 12	12	23
--- Level 4 Record 23	23
--- Level 4 Record 24	24

Try a different level?
Main Table | Level 2 Table | Level 3 Table | Level 4 Table

Back To Main Page

Download <cf_recordcount>

[ Home ] [ Site Design ] [ Hosting ] [ eCommerce ] [ ColdFusion ] [ About Us ] [ Contact ]