Hey Ben, I have a db table of users, of jobs and an xref table linking / "foreign keying" the two.
I need to produce an html table of 10 jobs (horizontally along the top of the page) and 30 users (listed vertically along the page) per page from a database of 200 users and 15 jobs. I will use cfdocument format="pdf" to print. If I were to produce a table of 14 columns and 200 rows, it would not print well (literally printed on a printer and given to a truck driver). I need the jobs listed as headers on each page of the printed pages. Regarding which data to show: per user, i was looking the xref to find user's id in the xref table. If it's there I output a value (the value part doesn't matter as I have that fig's out). If I have 200 users and I want 10 per page, that's 20 pages. But, only 10 jobs fit horizontally as headers. I would have to print the remaining 5 jobs on more pages. Does this make sense? This looping through tables and keeping track of table cells and rows is killing me. Kiley At 02:52 PM 5/12/2006, you wrote: >Kiley, > >The problem is a bit strange... Can you explain it in english and maybe we >can get you a better solution. How are you decided which data to show?? > >For example: > >I want to show the 30 most recent jobs for the 10 most active users. > >....................... >Ben Nadel >www.bennadel.com >-----Original Message----- >From: Kiley Simpson [mailto:[EMAIL PROTECTED] >Sent: Friday, May 12, 2006 4:48 PM >To: CF-Talk >Subject: table of unlimited jobs and users? > >Hi List, > >I have to print a grid/table (not cfgrid) of jobs along the >x-axis(horizontal) and users along the y-axis(vertical). > >Can someone show me how to make a table which will display 30 users along >the y-axis and 10 jobs along the x-axis knowing there are unlimited of each? > >10 x 30 for unlimited users and jobs. The end result is to use cfdocument >and make a printable pdf of the table. > >Many thanks, > >Kiley > > > > > > >Netmatrix >403 686-1169 >netmatrix.com > ><http://www.netmatrix.com>Unlock your web site with Web Management Matrix >Pro > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240417 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
