> 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 > Another rookie mistake - my ending cfoutput tag was outside the closing table tag. I moved it inside and all is well. Thank you all for the help!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3129 Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
