I'm sure I'm missing something simple here, but I can't see it. I'm running a simple query that kicks grouped categories out to an RTF file. I have the RTF header brought in via a SSinclude, and the query grouped by category.
Here's my page:
<CFQUERY DATASOURCE="manage" name="GetReports">
SELECT task_id, period, project_cat, task, budget_cat
FROM tasks
WHERE period = 12
ORDER BY period;
</cfquery>
<CFCONTENT TYPE="application/rtf">
<CFOUTPUT QUERY="GetReports" GROUP="project_cat"><CFINCLUDE TEMPLATE="rtfhdr.rtf">
Management Office
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f92\insrsid621974\charrsid2503161 Period Covered: }{\f92\insrsid2491611\charrsid2503161 #period#}{
\f92\insrsid11668967\charrsid2503161
\par }{\f1\insrsid621974\charrsid2503161
\par
The following represents the work accomplished in support of the Management Office.
\par }{\b\f1\insrsid621974\charrsid2503161
\par }{\f92\insrsid621974\charrsid2503161
<CFOUTPUT>
#project_cat#
\par {\listtext\pard\plain\f3\insrsid1274124\charrsid2503161 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls8\adjustright\rin0\lin720\itap0 {\f1\insrsid1274124\charrsid2503161
#task#</CFOUTPUT>
} } }
</CFOUTPUT>
My result:
Management Office
Period Covered: 12
The following represents the work accomplished in support of the Management Office.
CATEGORY 1
Continued transferring 2003 CAT data.CATEGORY 1
Continued update of Contracts module.CATEGORY 1
Continued development of new web-based data transfer system for 2004 Weapon Systems Handbook.
---------------
There are three categories in this particular query, but I'm only getting one found. I'm also getting the Category name attached to the first couple items on all list items except the last. Any clues about what I'm doing wrong?
Here's my page:
<CFQUERY DATASOURCE="manage" name="GetReports">
SELECT task_id, period, project_cat, task, budget_cat
FROM tasks
WHERE period = 12
ORDER BY period;
</cfquery>
<CFCONTENT TYPE="application/rtf">
<CFOUTPUT QUERY="GetReports" GROUP="project_cat"><CFINCLUDE TEMPLATE="rtfhdr.rtf">
Management Office
\par }\pard\plain \ql \li0\ri0\widctlpar\aspalpha\aspnum\faauto\adjustright\rin0\lin0\itap0 \fs24\lang1033\langfe1033\cgrid\langnp1033\langfenp1033 {\f92\insrsid621974\charrsid2503161 Period Covered: }{\f92\insrsid2491611\charrsid2503161 #period#}{
\f92\insrsid11668967\charrsid2503161
\par }{\f1\insrsid621974\charrsid2503161
\par
The following represents the work accomplished in support of the Management Office.
\par }{\b\f1\insrsid621974\charrsid2503161
\par }{\f92\insrsid621974\charrsid2503161
<CFOUTPUT>
#project_cat#
\par {\listtext\pard\plain\f3\insrsid1274124\charrsid2503161 \loch\af3\dbch\af0\hich\f3 \'b7\tab}}\pard \ql \fi-360\li720\ri0\widctlpar\jclisttab\tx720\aspalpha\aspnum\faauto\ls8\adjustright\rin0\lin720\itap0 {\f1\insrsid1274124\charrsid2503161
#task#</CFOUTPUT>
} } }
</CFOUTPUT>
My result:
Management Office
Period Covered: 12
The following represents the work accomplished in support of the Management Office.
CATEGORY 1
Continued transferring 2003 CAT data.CATEGORY 1
Continued update of Contracts module.CATEGORY 1
Continued development of new web-based data transfer system for 2004 Weapon Systems Handbook.
---------------
There are three categories in this particular query, but I'm only getting one found. I'm also getting the Category name attached to the first couple items on all list items except the last. Any clues about what I'm doing wrong?