Help! Iteration/Loop Problem

[Captain Ru]

<CFQUERY NAME="ticket_info" DATASOURCE="HelpDesk">
SELECT *
FROM Help_Desk_List a, NotesTbl b
WHERE a.Entry_ID = #Close_Ticket# AND b.Ticket_ID = #Close_Ticket#
ORDER BY b.Notes_Date DESC
</CFQUERY>


<cfset first = "yes">
<cfoutput query="ticket_info">
<cfif first is "yes">
<cfmail to="Ruel.*********@***********.com"
from="Helpdesk@***************.COM" subject="#Name# has closed ticket
#Entry_ID#."
server="10.1.100.202">
Ticket #Entry_ID# is Closed on #Date_Closed# by #Name#

Note History
<cfif entry_id is ticket_id>
Time of Entry: #Notes_Date#
Priority level: #Priority_Level#
Description: #Entry_Description#

Note: #Notes#
</cfif>
</cfmail>
<cfset first = "no">
</cfif>
</cfoutput>

I *want* 1 email with the body then have it loop over for x number of note
fields. I can only get it to write multiple emails, each with a separate note.

[The ScareCrow]

use the group attribute of the cfoutput tag, lets assume there are a number of
"notes" for each "entry_id"

<cfset first = "yes">
<cfoutput query="ticket_info" group="Entry_ID>
<cfif first is "yes">
<cfmail to="Ruel.*********@***********.com"
from="Helpdesk@***************.COM" subject="#Name# has closed ticket
#Entry_ID#."
server="10.1.100.202">
Ticket #Entry_ID# is Closed on #Date_Closed# by #Name#

Note History
<cfif entry_id is ticket_id>
Time of Entry: #Notes_Date#
Priority level: #Priority_Level#
Description: #Entry_Description#

<cfoutput>
Note: #Notes#
</cfoutput>
</cfif>
</cfmail>
<cfset first = "no">
</cfif>
</cfoutput>

Ken

[Captain Ru]

what in the....
for some reason, the close tickets is not working. 'add' sends an email, 'add notes' sends and email, but 'close ticket' isn't.

[Captain Ru]

got it
somehow a port found it's way there that shouldn't have