|
|
On Apr 17, 10:10 pm, "drdagwood" <webforumsu...@xxxxxxxxxxxxxx> wrote:
> Hello all,
> I'm pulling data from several tables and one of the tables happens to be
> all the comments associated with a specific job. I'm able to output the last
> comment in the system but I can't seem to figure out how to show all the
> comments as well. I've pasted the code below:
>
> Thanks,
>
> <cfset CurrentPage=GetFileFromPath(GetBaseTemplatePath())>
> <cfparam name="PageNum_getBilledJob" default="1">
>
> <cfset getBilledJob = listBilledJob()>
<snap>
> <cfoutput query="getBilledJob" startRow="#StartRow_getBilledJob#"
> maxRows="#MaxRows_getBilledJob#" group="jobNum">
<snap>
Now, your main output loop you can find it yourself if you read CF
docs) outputs the grouped info...
For detailed info within the group you can add ANOTHER inner
<cfoutput>...</cfoutput> within your main loop...
>
> <!---// This where I'd like all the comments associated with this job to be
> displayed //--->
<cfoutput>
> <cfif jcComment IS NOT "">
> <tr id="headerRpt">
> <td colspan="6" align="left"><a
> href="rptJobComments.cfm?jobNum=#jobNum#">[View All Notes]</a>Last Note:
> #jcComment#</td>
> </tr>
</cfoutput>
This way you will have a row per comment... You can do it anyway you
like, but you will have to think about it yourself...
> <cfelse>
>
> </cfif>
>
<snap>
And PLEASE, PLEASE, PLEASE read CF docs BEFORE you start asking
questions...
|
|