James, You can refer to a query record set using array/object notation:
<cfset value = Recordset1[ "client_#directories.Name#" ][ Recordset1.CurrentRow ] /> More generally, you can refer to a record set like this: RECORSET[ COLUMN_NAME ][ ROW_NUMBER ] Hope that helps. ...................... Ben Nadel Certified Advanced ColdFusion Developer www.bennadel.com -----Original Message----- From: James O'Dowd [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 7:29 AM To: CF-Talk Subject: how do i recordset with variables I'm setting up a website where customers of my client see specific documents that my client allows permissions to. This way the client needs to be able to create and rename fields. Consequently, when it comes to displaying contents of a recordset, i need to be able to list the fields dynamically. I need the code below: <cfif (#Recordset1.client_ongoingcontracts# EQ 1)>checked="checked"</cfif> to work like this: <cfif (#Recordset1.client_(directories.Name)# EQ 1)>checked="checked"</cfif> directories.Name is the variable pulling in from a cfdirectory listing. Any help would be greatly appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:258673 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
