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
I have have a problem in doing the cold fusion output (or the query) from
three tables. I have simplified my example to just the part that is the
problem -- hopefully I haven't simplified it too much. Basically I want a
nested cfoutput to do what I want, I would like to know if this is
UTPUT
OR you can even do this:
CFOUTPUT query="notices"
#title# #url# #information# #iconPath# #subnotices.title#
#subnotices.docType#
/CFOUTPUT
Hope that helps.
Bonnie E. Betts
[EMAIL PROTECTED]
www.interacttechs.com
- Original Message -
From: "Aimee Abbott" [EMAIL PROTECTED]
Subject: two queries (nested cfoutput?)
I have have a problem in doing the cold fusion output (or the query) from
three tables. I have simplified my example to just the part that is the
problem -- hopefully I haven't simplified it too much. Basically I want a
nested cfoutput to do what I want, I
From: "Aimee Abbott" [EMAIL PROTECTED]
To: "CF-Talk" [EMAIL PROTECTED]
Sent: Sunday, April 15, 2001 12:58 PM
Subject: two queries (nested cfoutput?)
I have have a problem in doing the cold fusion output (or the query) from
three tables. I have simplified my exampl
Yes, you are right, I would like to do it in two queries
also, I don't think what you described would work (but please
correct me if I am wrong). What I want is:
[icon] Notice(query one output)
[subIcon] subdocument (query two output)
[subIcon] subdocument (query two
6 matches
Mail list logo