if the query results are ordered by category then just: <cfoutput query="myQuery" group="category"> #category#<br> <cfoutput> loop through all sub-records here </cfoutput> </cfoutput>
+-----------------------------------------------+ Bryan Love Macromedia Certified Professional Internet Application Developer Database Analyst Telecommunication Systems [EMAIL PROTECTED] +-----------------------------------------------+ "...'If there must be trouble, let it be in my day, that my child may have peace'..." - Thomas Paine, The American Crisis -----Original Message----- From: Smith, Daron [PA] [mailto:[EMAIL PROTECTED]] Sent: Friday, May 10, 2002 11:48 AM To: CF-Talk Subject: Conditional Query loop Is it possible to loop over a query until a condition is met? Specifically, I am returning search results, if a certain category exists i want to display a title, if no records for that category exist I do not want to display the title. However I only want to display the title one time if the records exist. Looping over the query will display the title the number of times that the condition exists in the recordset, but a conditional query doesn't appear to allow a query to loop over. Thanks for any help, Daron J. Smith Web Developer PSEA [EMAIL PROTECTED] 717-255-7141 1-800-944-PSEA (7732) x 7141 Please note new email address (old one with 'mail' will soon expire) 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 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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