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 and then 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 wrote: > I've never been able to us

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 www.myspace.com/b

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 wrote: > > Hi Pete, > You don't need the hash signs around your table name in a QoQ: > > > > > > SELECT * > FROM arguments.dataIn > ORDER BY #arguments.orderby# > > > > > Should work. > > Francois Leve

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: SELECT * FROM arguments.dataIn ORDER BY #arguments.orderby# Should work. Francois Levesque http://blog.critical-web.com/ On Mon, Jul 20, 2009 at 1:00 PM, Pete Ruckelshaus wrote: > > I'm stuck. Actually, I'm