[farcry-dev] Re: How can get the name of a parent alias?

[Jeff Coughlin]

Okay, this is what I came up with so far.  Can anyone tell me if their 
is a cleaner or better way to do this?  (Or should this be fine).

<!--- Start code --->
<cfset qAncestors = 
request.factory.oTree.getAncestors(objectID=request.navid)>
<cfset qNodes = request.factory.oTree.getNode(objectID=request.navid)>
<cfloop query="qNodes">
	<cfif qNodes.nLevel gte 3>
		<cfquery name="qChkAncestors" dbtype="query">
		SELECT * FROM	qAncestors
		WHERE ObjectName = 'TopNav' AND nLevel = 2
		</cfquery>
		<cfif qChkAncestors.RecordCount>
			Do Something
		</cfif>
	</cfif>
</cfloop>
<!--- End code --->

Regards,
Jeff Coughlin
http://www.jeffcoughlin.com/
---
You are currently subscribed to farcry-dev as: [EMAIL PROTECTED]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/