Sorry, but I find the easiest way is to re-build the array as a string like so:
<@ASSIGN SCOPE=local NAME=StudentEmails VALUE="">
<@ROWS ARRAY=Students>
<@ASSIGN
NAME=StudentEmails
VALUE="<@VAR StudentEmails><@IFEQUAL <@NUMROWS>
1><@ELSE>,</@IF><<@VAR Students[<@CURROW>,emailAddress]>>">
</@ROWS>
The <@IF> skips the first row, and adds a comma before the rest of the
addresses
Anthony -
-----Original Message-----
From: Campbell, Steve V. [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 4:43 PM
To: Anthony M. Humphreys
Cc: [EMAIL PROTECTED]
Subject: RE: Re: Witango-Talk: (OT) Email Action Question
Okay
This makes sense and will work much easier. Now one more question if I
may please.
To get the email address from all the students in one class into one
email, I of course pulling out an array of that column.
The problem I have is I can't get it out of the Table format. I am aware
of the array to text conversion attributes aprefix..etc.
Is there anywhere in the manual that I have overlooked that shows this.
I have even tried this:
<@ASSIGN NAME="myArray" SCOPE=Local VALUE="<@ARRAY
VALUE='@@studentArray4' CDELIM=';' RDELIM='~'>">
And of course..this didn't even get me close. Any ideas?
Thanks
Steve
-----Original Message-----
From: Anthony M. Humphreys [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 12:44 PM
To: Campbell, Steve V.
Subject: RE: Re: Witango-Talk: (OT) Email Action Question
Yes, try something a bit simpler, like this:
<@IF EXP<@ARG completed>>
Completed
<@ELSEIF <@ARG cancelled>>
Cancelled
<@ELSEIF <@ARG noshow>>
Noshow
</@IF>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Campbell, Steve V.
Sent: Thursday, May 16, 2002 11:16 AM
To: Multiple recipients of list witango-talk
Subject: RE: Re: Witango-Talk: (OT) Email Action Question
Question regarding what can be done in an email action.
I am sending out an email after an instructor records via web interface
whether or not a student has completed, cancelled or no showed a class
they have enrolled in.
Basically in the database it's a "1 or a 0" if they completed,
cancelled..etc.
In my email action ..I have something like the following:
<@ARG Name> has just been recorded as
<@ARG completed>
<@ARG cancelled>
<@ARG noshow>
the following class.
<@ARG class> that was on <@ARG class_date>.
What I am having problems with is it possible to do the following:
<@IF EXP<@ARG completed>=1>
<@ARG completed>
<@ELSEIF EXP<@ARG completed=0>
<@IF>
Am I on the right track here? And can it be done in an email action?
Thanks for any help
Steve
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
<<attachment: winmail.dat>>
