----- Original Message -----
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/
---