I think you need to change <CFOUTPUT>#getSubCategories(CatID)#</CFOUTPUT> to <cfset temp = temp & getSubCategories(CatID)>
And you also need to set temp as a local var in your function by placing <cfset var temp = ""> neat the top. You should always do that when working with vars inside functions, and particularly in this case. -----Original Message----- From: Samantha Brinkley [mailto:[EMAIL PROTECTED] Sent: Wednesday, 28 December 2005 11:46 a.m. To: CF-Talk Subject: Re: Accounting for Unknown Number of Loops Thank you. That was exactly it. Well, at least to solve that problem. I've renamed the query and now I'm not getting that error. Now, I'm getting too many entries on the display page. My "temp" variable clearly is adding on to itself when I don't want it to, but I've tried some things and they're not working. Instead of getting: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:227731 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
