Using an Iterator With a Custom Query
The Mura contentIterator can decorate any query that contains the columns "SiteID" and "ContentID".
<cfscript> queryService=new Query(); queryService.setSQL( 'SELECT contentID, siteid FROM tcontent WHERE parentID = :parentID AND siteID = :siteID AND active = 1' ); queryService.addParam( name='parentID' , cfsqltype='cf_sql_varchar' , value=$.content('contentID') ); queryService.addParam( name='siteID' , cfsqltype='cf_sql_varchar' , value=$.content('siteID') ); rs=queryService.execute().getResult(); iterator=$.getBean('contentIterator'); iterator.setQuery(rs); </cfscript> <cfoutput> <cfif iterator.hasNext()> <ul> <cfloop condition="iterator.hasNext()"> <cfset item=iterator.next()> <li> <a href="#item.getURL()#"> #HTMLEditFormat(item.getMenuTitle())# </a> </li> </cfloop> </ul> <cfelse> <p class="alert alert-info">No items in the iterator!</p> </cfif> </cfoutput>