[cfaussie] Re: Missing a loop somewhere

[Dean Brandt]

Title: Message

Hi Mat,       Yes that cured the problem, many thanks.       I got plenty of other replies too, thanks also to those people.       Regards     Dean Brandt Clever Thinking Consulting Network/Systems Integration, Application Design Melbourne, Australia 0418488885 ...smart networks for smart business -----Original Message----- From: Mat Bryant [mailto:[EMAIL PROTECTED] Sent: Wednesday, 5 March 2003 12:41 PM To: CFAussie Mailing List Subject: [cfaussie] Re: Missing a loop somewhere The email variable needs to be set inside the CFOUTPUT.   Cheers,   mat ----- Original Message ----- From: Dean Brandt To: CFAussie Mailing List Sent: Wednesday, March 05, 2003 2:27 PM Subject: [cfaussie] Missing a loop somewhere       Hi all       I am trying to send an email to the assigned person in a task list using this code:     <cfoutput query="latetasks"> <cfmail  From="taskmanager@domain.com.au"  Subject="Task is overdue"  To=#email#>  The task ID is: #task_id#  The task description is: #description#  The task was due for completion on #DateFormat(scheduled_completion, "D MMMM YYYY")#  Please visit www.cleverthinking.com.au to update your task. </cfmail>  </cfoutput>         What is happening is that it sends all emails to one person rather than sending each item to its owner.       #email# is defined by a cfset earlier in the code. ie if a task is assigned to id number 2:   <cfif #assigned_to#='2> <cfset person='username'>   then   <cfif #person='Joe Blow> <cfset #email#='[EMAIL PROTECTED]'>         Can anyone see any glaring faults with this? Obviously there's at least one :)       Thanks   Dean Brandt Clever Thinking Consulting Network/Systems Integration, Application Design Melbourne, Australia 0418488885 ...smart networks for smart business --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/