Use the Mura Iterator with a custom query

mura-custom-query-iterator.cfm

<cfquery name="rsExample">
	SELECT content,siteID 
	FROM tcontent
	WHERE .....
</cfquery>
<cfset it=application.serviceFactory.getBean("contentIterator")>
<cfset it.setQuery(rsExample)/>
<!--- Now Iterate and pull attributes that aren't in the query --->
<cfloop condition="it.hasNext()">
	<cfset item=it.next()>
	<cfoutput>
		#it.currentIndex()#: #item.getMenutitle()# - #item.getCustomVar()#</br>
	</cfoutput>
</cfloop>

<!--- You can even set items in your iterator with new values --->
<cfloop condition="it.hasNext()">
	<cfscript>
		item=it.next();
		item.setIsNav(0); // turn off navigation
		item.save() // save the content bean
	</cfscript>
</cfloop>