You could try...
rsRecordsetName['filedName']
to be specific...associative array type notation.
Niall.
-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: 30 January 2007 18:35
To: CF-Talk
Subject: Re: Referring to a specific field in a query
alias one (or both of) the column names in the query.
CF knows nothing about the tables (so you can't do
#queryname.tablename.column#).
On 1/30/07, Nathan C. Smith <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I have two queries that have some overlapping names that I am using in a
> cfoutput together (CF MX7)
>
> #QueryName.field usually seems to do the trick, but if I wanted to be
really
> specific, is there something like
>
> Queries.queryname.tablename.field
>
> In order to refer very specifically to a field. It becomes a bit
confusing
> using a fieldname from one query as a variable in another query.
(normally
> I try to let the database do the work, but this database is Access and the
> fields are a little convoluted). I realize I could rename the fields in
the
> query if I need to.
>
> Thanks.
>
> -Nate
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268156
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
