Is the data in the second query related to the first? Or is it completely disjointed from the first query?
If it's unrelated, you could build the HTML outside the first CFOUTPUT block and dump it to a variable for later. If your data is related to the original query, you'll have to use nested CFLOOPS or perhaps a custom tag... HTH, 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:41 PM To: CF-Talk Subject: Re: Outputting issue 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 > > ______________________________________________________________________ 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
