Working on a new application and I wanted to use UDFs to call queries and return the recordset.
Not getting the results I am expecting. Never really worked with running queries inside of <cfscript> And not seeming o be able to pass the recordset name to the function. <cfscript> function fncQryGetAllUsers(recordset,orderby,sort) { <cfquery name="#recordset#" datasource="DATABASE"> SELECT * FROM USERS ORDER BY #orderby# #sort# </cfquery> } </cfscript> This is the code im using, but also how would I set the recordset as a return Parameter? So that I could do something like this. <cfloop query="#fncQryGetAllUsers('recordsetname','last_name','desc')#"> </cfloop> Anyone done anything like this? Have any ideas? -chris.alvarado [ application developer ] 4 Guys Interactive, Inc. http://www.4guys.com -- I can picture in my mind a world without war, a world without hate. And I can picture us attacking that world, because they'd never expect it. -- Jack Handy ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists