If you use CFMX then you can indeed create queries inside of a UDF. And either way, you can pass a query to a UDF. If you are using <CFSCRIPT> syntax then you'll need to use a loop and access the query members as query.column[row].
--- Ben -----Original Message----- From: Chris Edwards [mailto:[EMAIL PROTECTED]] Sent: Monday, July 29, 2002 12:57 PM To: CF-Talk Subject: DB Queries and UDFs It is my understanding that I cannot run DB queries inside of a UDF. If there is a way, I would like that alot. If there isn't, may I pass the Query results into the UDF? If I can, is it just the name of the query? Is it an Array? Thanks! ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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