(Admittedly this problem for us occurred when we used a defined LOCAL scope inside the function... ie <cfset var LOCAL = structNew()> and then <cfquery name="LOCAL.qry" datasource="whatever")> and then in a query of queries... we'd always get errors when trying to do select * from LOCAL.qry
Rick On Mon, Jul 20, 2009 at 1:17 PM, Rick Root<rick.r...@webworksllc.com> wrote: > I've never been able to use a multipart identifier for a table in > query of queries until we figured out that it does let you put > brackets in... > > ie... > > FROM [arguments.dataIn] -- Rick Root New Brian Vander Ark Album, songs in the music player and cool behind the scenes video at www.myspace.com/brianvanderark ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324738 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4