Hi Brian, I think you'll find GetRows and GetString to be extremely helpful. You don't have to manipulate slow, clumsy recordsets, and if you format the results correctly, you might be able to avoid doing any string concatenation at all. http://learnasp.com/freebook/asp/whygetrows.aspx Cheers, Peter ---------------------------------------- From: Brian Delaney <brian.delaney at mccmh.net> Sent: Friday, April 21, 2006 8:51 AM To: "thelist at lists.evolt.org" <thelist at lists.evolt.org> Subject: [thelist] asp LOGIC QUESTION I have a sql record set that contains 12 uids. For each UID I want to go the servie table and return the services that are under this catagory's ID Once I get the list of services I want to dynamically build the html for display.. The problem is this: I can loop through the catagory recoredset and find the services per uid I just am stuck on how to create a dynaic unique variable name to hold teh html for each service list. The ASP code: While Not rsCatagoryList.EOF Set rsServiceList = Server.CreateObject("ADODB.Recordset") strSQL1 = "Select * from Services where catagoryid = " & "'" & mid(rsCatagoryList("ID"),2,36) & "'" & " order by name " rsServiceList.Open strSQL1, ResourceCatalogDBConn While Not rsServiceList.EOF ServiceListHTML = "<-- Choose One -->" ServiceListHTML = ServiceListHTML1 & "" & rsCatagoryList("Name") & "" rsServiceList.MoveNext Wend rsCatagoryList.MoveNext Wend The HTML Code: Activities / Recreation: any help will be appreciated, thanks * * * This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message. -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !