Move your opening and closing CFOUTPUT tags to surround only the TR tags that you want to repeat over.
Hope this helps william -----Original Message----- From: "Adam Parker" <[EMAIL PROTECTED]> To: "CF-Newbie" <[email protected]> Sent: 10/26/2007 1:58 PM Subject: Loop Through Query While Counting Hi All - I have a SQL table that I am querying to display members' information into a table. I am using: <cfoutput query="getMember"> <table id="tbl_people"> <tbody> <tr> <th scope="col"></th> <th scope="col">Person</th> <th scope="col">Discipline</th> <th scope="col" width="132">Phone</th> <th scope="col">E-mail</th> </tr> <tr> <td></td> <td><h3>#firstName# <cfif Trim(middleName) is "">#lastName#<cfelse>#middleName# #lastName#</cfif></h3> <p>#office#</p> <ul> <li><h4>#title#</h4></li> </ul> </td> <td>#discipline#</td> <td>#phone#</td> <td><a href="mailto:#netid#>#netid#</a></td> </tr> </tbody> </table> </cfoutput> This outputs the data, but the column headings are repeated instead of only displaying once at the top of the columns. I also want to count off the results as they are displayed. I'm not quite sure where to go with this. Can anyone offer help? Thank you, Adam ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3126 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
