<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#
Main Record 1	1	1
--- Level 2 Record 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	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
Main Record 2	2	9
--- Level 2 Record 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	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
Main Record 3	3	17
--- Level 2 Record 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	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
Main Record 4	4	25
--- Level 2 Record 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	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
Main Record 5	5	33
--- Level 2 Record 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	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
Main Record 6	6	41
--- Level 2 Record 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	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
Main Record 7	7	49
--- Level 2 Record 13	49
------ Level 3 Record 25	49
--------- Level 4 Record 49	49
--------- Level 4 Record 50	50
------ Level 3 Record 26	51
--------- Level 4 Record 51	51
--------- Level 4 Record 52	52
--- Level 2 Record 14	53
------ Level 3 Record 27	53
--------- Level 4 Record 53	53
--------- Level 4 Record 54	54
------ Level 3 Record 28	55
--------- Level 4 Record 55	55
--------- Level 4 Record 56	56
Main Record 8	8	57
--- Level 2 Record 15	57
------ Level 3 Record 29	57
--------- Level 4 Record 57	57
--------- Level 4 Record 58	58
------ Level 3 Record 30	59
--------- Level 4 Record 59	59
--------- Level 4 Record 60	60
--- Level 2 Record 16	61
------ Level 3 Record 31	61
--------- Level 4 Record 61	61
--------- Level 4 Record 62	62
------ Level 3 Record 32	63
--------- Level 4 Record 63	63
--------- Level 4 Record 64	64
Main Record 9	9	65
--- Level 2 Record 17	65
------ Level 3 Record 33	65
--------- Level 4 Record 65	65
--------- Level 4 Record 66	66
------ Level 3 Record 34	67
--------- Level 4 Record 67	67
--------- Level 4 Record 68	68
--- Level 2 Record 18	69
------ Level 3 Record 35	69
--------- Level 4 Record 69	69
--------- Level 4 Record 70	70
------ Level 3 Record 36	71
--------- Level 4 Record 71	71
--------- Level 4 Record 72	72
Main Record 10	10	73
--- Level 2 Record 19	73
------ Level 3 Record 37	73
--------- Level 4 Record 73	73
--------- Level 4 Record 74	74
------ Level 3 Record 38	75
--------- Level 4 Record 75	75
--------- Level 4 Record 76	76
--- Level 2 Record 20	77
------ Level 3 Record 39	77
--------- Level 4 Record 77	77
--------- Level 4 Record 78	78
------ Level 3 Record 40	79
--------- Level 4 Record 79	79
--------- Level 4 Record 80	80
Main Record 11	11	81
--- Level 2 Record 21	81
------ Level 3 Record 41	81
--------- Level 4 Record 81	81
--------- Level 4 Record 82	82
------ Level 3 Record 42	83
--------- Level 4 Record 83	83
--------- Level 4 Record 84	84
--- Level 2 Record 22	85
------ Level 3 Record 43	85
--------- Level 4 Record 85	85
--------- Level 4 Record 86	86
------ Level 3 Record 44	87
--------- Level 4 Record 87	87
--------- Level 4 Record 88	88
Main Record 12	12	89
--- Level 2 Record 23	89
------ Level 3 Record 45	89
--------- Level 4 Record 89	89
--------- Level 4 Record 90	90
------ Level 3 Record 46	91
--------- Level 4 Record 91	91
--------- Level 4 Record 92	92
--- Level 2 Record 24	93
------ Level 3 Record 47	93
--------- Level 4 Record 93	93
--------- Level 4 Record 94	94
------ Level 3 Record 48	95
--------- Level 4 Record 95	95
--------- Level 4 Record 96	96

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 ]