Mark, Is this what you are looking for
<cfset "link#linkIndex#" = linkIndex> ? HTH Ricardo On 6/14/05, Mark Henderson <[EMAIL PROTECTED]> wrote: > Quick question. Is it possible to take a predefined variable and add > that as part of another variable name inside cfset. > > Here is my example. > > <cfquery name = "qryLinkMaster" datasource = "#request.dsn#"> > SELECT link_ID, > name, > url, > comment, > category, > active > FROM links > WHERE active = Yes > </cfquery> > > > And using QoQ > > <cfset linkItems = "Drivers,Security,Search,Partner,Admin" /> > <cfloop index="linkIndex" list="linkItems"> > <cfquery dbtype="query" name="qry#linkIndex#Links"> > SELECT * > FROM qryLinkMaster > WHERE category = '#lcase(linkIndex)#' > </cfquery> > <!--- here is my problem ----> > <cfset link(insert linkIndex value to variable name here) = linkIndex > </cfloop> > > But before the loop ends I want to be able to name a variable WITH the > relevant linkIndex in its name (to make it unique) so that in the above > example I would have > linkDrivers,linkSecurity,linkSearch etc defined as variables. It wont > let me add a predefined variable to a one new one and I keep getting > syntax errors. > > Any ideas?? > > TIA > Mark > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:209372 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
