use a cfoutput with group attribute instead? <cfoutput query="GetStates" group="StateID"> #GetStates.StateName# #GetStates.StateID# - <cfoutput group="RegionID"> #GetStates.StateRegion# #GetStates.RegionID#<BR /> <cfoutput group="CountryID"> <cfoutput> <A HREF="property1.cfm?PropertyLocationID=#GetStates.PropertyLocationID#" class="leftnav">#GetStates.PropertyLocationName#</A><BR /><img src="images/1x1black.gif" width="100%" height="1" vspace="2" /><BR /> </cfoutput> </cfoutput> </cfoutput> </cfoutput>
Azadi On 03/08/2011 09:59 , Chris Sizemore wrote: > I am using a cfloop condition approach to perform a standard branched tree > operation. I have four tables and my query is pretty straight forward. The > output is not working though. It is returning the correct amount of results > and is organizing them properly but the values displayed are repeating. I've > looked over it again and again. It returns the proper fields and order in > MSSQL Server Management Studio Express... Any ideas? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346473 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
