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 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
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/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:324736 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 Levesque > http://blog.critical-web.com/ > > > On Mon, Jul 20, 2009 at 1:00 PM, Pete Ruckelshaus >wrote: > > > > > 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: > > > > > > > > > > SELECT top 100 * > > FROM person.contact > > > > > > > > > > > > > > > > SELECT * > > FROM #arguments.dataIn# > > ORDER BY #arguments.orderby# > > > > > > > > > > > > And here's the important stuff from my calling page: > > > > > returnvariable="getContacts"> > > > returnvariable="getContacts1"> > > > > > > > > > > The problem is that the CFC is throwing a "Complex object types cannot be > > converted to simple values." error. How do I get the sortDataFromQry > > function to see dataIn as a recordset? > > > > Thanks > > > > Pete > > > > > > > > ~| 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:324735 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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 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: > > > > > SELECT top 100 * > FROM person.contact > > > > > > > > SELECT * > FROM #arguments.dataIn# > ORDER BY #arguments.orderby# > > > > > > And here's the important stuff from my calling page: > > returnvariable="getContacts"> > returnvariable="getContacts1"> > > > > > The problem is that the CFC is throwing a "Complex object types cannot be > converted to simple values." error. How do I get the sortDataFromQry > function to see dataIn as a recordset? > > Thanks > > Pete > > > ~| 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:324732 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
