it does not matter what your query selects... it matters what from that query you are returning... you query may select 1 field in 1 row - it will still be a query, and you can cfreturn it as such if you want to. or your query may return thousands of rows of thousands of columns - but you cfreturn a reference to one specific column in one specific row, which will be a string/integer/etc/etc
it IS late here in Laos... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Rick Faircloth wrote: > So, let's see if I've got this straight. > > If I want to use the cfreturn result from a query > in a cfc that is only *one* piece of info, > (as in 'select username' I don't have > to use the returntype of 'query'. > > But, if I want to access *all* the data returned by a query > in a cfc, (as in 'select *' I have to use returntype = 'query'. > > Correct? > > Rick > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307508 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
