Passing a query object to a CFC and then using that for a query of queries?

I'm stuck. Actually, I'm probably just being stupid. I want to pass a query object into a CFC and then use query of queries to manipulate that query object. Here's the contents of my db.cfc file: cfcomponent cffunction name=getContacts returntype=query cfquery name=getData

Re: Passing a query object to a CFC and then using that for a query of queries?

Hi Pete, You don't need the hash signs around your table name in a QoQ: cffunction name=sortDataFromQry returntype=query cfargument name=dataIn type=query required=yes cfargument name=orderBy type=string required=yes cfquery name=getData dbtype=query SELECT * FROM arguments.dataIn ORDER BY

Re: Passing a query object to a CFC and then using that for a query of queries?

That was it, Francois. Thanks. On Mon, Jul 20, 2009 at 1:05 PM, Francois Levesque cfab...@gmail.comwrote: Hi Pete, You don't need the hash signs around your table name in a QoQ: cffunction name=sortDataFromQry returntype=query cfargument name=dataIn type=query required=yes cfargument

Re: Passing a query object to a CFC and then using that for a query of queries?

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

Re: Passing a query object to a CFC and then using that for a query of queries?

(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