<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 2 Record 1	1	1
--- Level 3 Record 1	1
------ Level 4 Record 1	1
------ Level 4 Record 2	2
--- Level 3 Record 2	3
------ Level 4 Record 3	3
------ Level 4 Record 4	4
Level 2 Record 2	2	5
--- Level 3 Record 3	5
------ Level 4 Record 5	5
------ Level 4 Record 6	6
--- Level 3 Record 4	7
------ Level 4 Record 7	7
------ Level 4 Record 8	8
Level 2 Record 3	3	9
--- Level 3 Record 5	9
------ Level 4 Record 9	9
------ Level 4 Record 10	10
--- Level 3 Record 6	11
------ Level 4 Record 11	11
------ Level 4 Record 12	12
Level 2 Record 4	4	13
--- Level 3 Record 7	13
------ Level 4 Record 13	13
------ Level 4 Record 14	14
--- Level 3 Record 8	15
------ Level 4 Record 15	15
------ Level 4 Record 16	16
Level 2 Record 5	5	17
--- Level 3 Record 9	17
------ Level 4 Record 17	17
------ Level 4 Record 18	18
--- Level 3 Record 10	19
------ Level 4 Record 19	19
------ Level 4 Record 20	20
Level 2 Record 6	6	21
--- Level 3 Record 11	21
------ Level 4 Record 21	21
------ Level 4 Record 22	22
--- Level 3 Record 12	23
------ Level 4 Record 23	23
------ Level 4 Record 24	24
Level 2 Record 7	7	25
--- Level 3 Record 13	25
------ Level 4 Record 25	25
------ Level 4 Record 26	26
--- Level 3 Record 14	27
------ Level 4 Record 27	27
------ Level 4 Record 28	28
Level 2 Record 8	8	29
--- Level 3 Record 15	29
------ Level 4 Record 29	29
------ Level 4 Record 30	30
--- Level 3 Record 16	31
------ Level 4 Record 31	31
------ Level 4 Record 32	32
Level 2 Record 9	9	33
--- Level 3 Record 17	33
------ Level 4 Record 33	33
------ Level 4 Record 34	34
--- Level 3 Record 18	35
------ Level 4 Record 35	35
------ Level 4 Record 36	36
Level 2 Record 10	10	37
--- Level 3 Record 19	37
------ Level 4 Record 37	37
------ Level 4 Record 38	38
--- Level 3 Record 20	39
------ Level 4 Record 39	39
------ Level 4 Record 40	40
Level 2 Record 11	11	41
--- Level 3 Record 21	41
------ Level 4 Record 41	41
------ Level 4 Record 42	42
--- Level 3 Record 22	43
------ Level 4 Record 43	43
------ Level 4 Record 44	44
Level 2 Record 12	12	45
--- Level 3 Record 23	45
------ Level 4 Record 45	45
------ Level 4 Record 46	46
--- Level 3 Record 24	47
------ Level 4 Record 47	47
------ Level 4 Record 48	48

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 ]