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:268089 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4