getSubPages returns the query, so you need to treat the result as if it
were a query object (just like you would treat the name attribute of a
CFQuery tag:
<!--- Get query (for shorthand). --->
<cfset qSubPages = getSubPages( 3 ) />
<!--- Tread qSubPages like it is a standard query (which it is). --->
<cfloop query="qSubPages">
....#qSubPages.COLUMN_NAME_GOES_HERE#
</cfloop>
......................
Ben Nadel
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-----Original Message-----
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 18, 2007 2:25 PM
To: CF-Talk
Subject: database function
Hello,
I am new to cfc's, functions etc...
I have a query that will be used many times and would like to keep the
query code in a single file then just call that function when I need it.
So say I do this:
<CFFUNCTION NAME="getSubPages" RETURNTYPE="query">
<CFARGUMENT NAME="pageID" TYPE="string" REQUIRED="yes">
<cfquery datasource="#application.dsn#" name="SubPages">
SELECT *
FROM PageContent
WHERE ParentID = #arguments.pageID#
</cfquery>
<CFRETURN SubPages>
</CFFUNCTION>
How do I call this function then loop over the returned results?
I cant find an example of doing this and everything I have tried has not
worked.
I should just be able to do this right? #getSubpages("3")# but I get
errors about complex data type.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:266922
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
