Try using the group attribute in your CFOUTPUT. <CFOUTPUT query="getitems" group="header"> #Header# <CFOUTPUT> #Type# -- #id# -- #Name# </CFOUTPUT> </CFOUTPUT>
You should also use an order by clause in your select statement... Jeff Garza Lead Developer/Webmaster Spectrum Astro, Inc. 480.892.8200 [EMAIL PROTECTED] http://www.spectrumastro.com -----Original Message----- From: Paul Giesenhagen [mailto:[EMAIL PROTECTED]] Sent: Monday, February 04, 2002 1:30 PM To: CF-Talk Subject: Outputting issue Ok, I have a pretty basic question, but haven't used it much in the past so I am needing alittle help. I have a query: <cfquery datasource="datasource" name="getitems"> Select header,type,id,name from items </cfquery> Each item coming from the above query has a header value, and I want to display the results as such: HEADER1 ITEM 1 ITEM 2 ITEM 3 HEADER2 ITEM 4 ITEM 5 ITEM 6 HEADER 3 blah blah How do I do this without multiple queries... Thanks (I know it's basic) Paul Giesenhagen QuillDesign http://www.quilldesign.com SiteDirector - Commerce Builder ______________________________________________________________________ Why Share? Dedicated Win 2000 Server � PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
