You can change the nested cfoutput for a query cfloop:
<CFQUERY NAME="notices" DATASOURCE="newsAndNotices">
select notice.noticeID, notice.title, notice.url, notice.information,
documents.iconPath
from notices, documents
where notice.docType = documents.docTypeID
</CFQUERY>
<cfoutput query="notices">
<img src="#iconPath#"> <a href="#url#">#title#</a>
<CFQUERY NAME="subs" DATASOURCE="newsAndNotices">
select subnote.title as subTitle, subnotes.url as subUrl,
documents.iconPath as subIcon
from subnote, documents
where notice.noticeID = subnote.noticeID and
subnote.docType = documents.docTypeID and
subnote.noticeID = #noticeID#
</CFQUERY>
<cfloop query="subs"> (Instead of <cfoutput query="subs">) <<< This is
where the trouble is!
<img src="#subIcon#"> <a href="#subUrl#">#subTitle#</a>
</cfloop> (Instead of </cfoutput>)
</cfoutput>
Jose Alberto Guerra Ugalde
Mail: [EMAIL PROTECTED]
My ICQ page: http://www.mirabilis.com/1607021
My ICQ:1607021
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
