RE: how do i recordset with variables

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. ..

Re: how do i recordset with variables

James - try the evaluate function for a quick solution On 01/11/06, James O'Dowd [EMAIL PROTECTED] wrote: 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.

Re: how do i recordset with variables

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

Re: how do i recordset with variables

Actually while you're here, i just need a little help with the last part of this page, it's to do with the insert function when it's updating the record. I need it to cycled through the directories and update accordingly. Below is a snippet of code i'm using at the moment, which is obviously

RE: how do i recordset with variables

-Original Message- From: James O'Dowd [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 8:11 AM To: CF-Talk Subject: Re: how do i recordset with variables Actually while you're here, i just need a little help with the last part of this page, it's to do with the insert function when it's