What if I cannot do an OUTPUT query="getitems" (already inside of an output) .
----- Original Message ----- From: "Garza, Jeff" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, February 04, 2002 2:35 PM Subject: RE: Outputting issue > 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 > > ______________________________________________________________________ Get Your Own Dedicated Windows 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=coldfusionb 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
