Thank you, thank you, thank you, thank you, thank you. Now i realise it's uses the same syntax as flash when you're using variables inside other variables. Makes sense i suppose seeing as they're both by Adobe nee Macromedia!
Thanks again. I was getting rather frustrated by this and couldn't work it out at all. -James >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:258677 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4