[cfaussie] RE: Missing a loop somewhere

[Steve Onnis]

Title: Message

Dean   Have you tried outputting the value of #Email# before you do the emails?   Try something like this   <cfoutput query="latetasks"> #email#<br> </cfoutput>   If you get the same email all the time, thens its your code above your email that sets the "Email" value.  If so I would check the values of #Assign_To# Regards Steve Onnis Domain Concept Designs +61 422 337 685 +61 3 9431 4249 http://www.domainconceptdesigns.com [EMAIL PROTECTED] http://www.cfcentral.com.au [EMAIL PROTECTED] ("If you think it can't be done, you haven't asked me!") - Steve Onnis   -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Dean Brandt Sent: Wednesday, March 05, 2003 12:28 PM To: CFAussie Mailing List 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/