 |
 |
 |
|
 |
|
 |
|
 |
|
 |
|
 |
<cf_recordcount>
|
This custom tag will allow you to use startrow and maxrows on a query driven, grouped cfoutput.
It is generally difficult to use Next 'n (Previous/Next) Records
on the cfoutput of the query results from a query join. <cf_recordcount> will parse the records from any of the tables you specify from a query join, allowing you to do Next 'n Records on those results. You have the choice of using form buttons or text and graphic links. We demo both the links and form buttons. Here is what our query looks like.
SELECT M.*,G.*,S1.*,S2.*
FROM Main M,Groups G,SubGroup1 S1,SubGroup2 S2 WHERE M.Main_ID = G.Main_ID and G.Group_ID = S1.Group_ID and S1.SubGroup1_ID = S2.SubGroup1_ID ORDER BY M.Main_ID,G.Group_ID,S1.SubGroup1_ID,S2.SubGroup2_ID |
Click below below to give it a try.
Next 'n Records with links. Click the level to output on.
Main Table |
Level 2 Table |
Level 3 Table |
Level 4 Table
[ Home ] [ Site Design ] [ Hosting ] [ eCommerce ] [ ColdFusion ] [ About Us ] [ Contact ]