Try this... I didn't do the caps thing like you are doing but you should get the jist!
<cfquery name="qr_states" datasource="CaptekLab"> SELECT s.state, l.lab_name FROM tblstate s, tbllabs l WHERE s.pk_tblSTATEID = l.fk_tblSTATEID GROUP BY s.state, l.lab_name </cfquery> <cfoutput query="qr_states" group="CaptekLab.state"> #qr_states.state#<br> <cfoutput>#qr_states.lab_name#</cfoutput> </cfoutput> Good Luck Paul Giesenhagen QuillDesign ----- Original Message ----- From: "Joshua Tipton" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 9:10 PM Subject: Output Help > Okay I fell stupid asking this because I have accomplished this many > times I just cant rememeber tonight. > > > > > > <cfquery name="qry_STATES" datasource="CaptekLab"> > > SELECT PK_tblSTATEID, State > > FROM dbo.tblSTATE > > </cfquery> > > <table> > > <cfloop query="qry_states"> > > <cfquery name="qry_labs" datasource="CaptekLab"> > > SELECT FK_tblSTATEID, Lab_Name, Lab_City, Lap_Phone > > FROM tblLABS > > where fk_tblSTATEID = '#qry_states.pk_tblSTATEID#' > > </cfquery> > > > > > > > > > > <cfoutput query="qry_labs"> > > <tr> > > <td>#qry_states.state#</td> > > <td>#Lab_name#</td> > > </tr> > > </cfoutput> > > </cfloop> > > </table> > > > > > > I want the state name output once and then a list of all the labs for > that state > > > > IE > > > > > > Alaska Lab1 > > Lab2 > > Lab3 > > > > Alabama Lab1 > > Lab2 > > Lab3 > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists