On 26/02/2010 19:59, Jeremy Harris wrote:
>> During the data phase, $recipients contains a comma separated list of
>> all the recipients. If you wanted to do an INSERT into an SQL database
>> at that point for each individual recipient, you could use a stored
>> function and loop over each address via the comma delimiter inside that
>> function. Another alternative would be to copy $recipients into an acl
>> variable and then use a recursive acl which pops off the top address,
>> inserts, and then calls it's self. As long as you take into account
>> recursion limits.
>
> If you can write your SQL as a one-liner exim expansion, you can
> walk a list with (e.g.) ${filter {}{}}
>
> Recursion not needed.
I always forget about those "new" functions. That would be a nicer
solution yes.
--
Mike Cardwell : UK based IT Consultant, Perl developer, Linux admin
Cardwell IT Ltd. : UK Company - http://cardwellit.com/ #06920226
Technical Blog : Tech Blog - https://secure.grepular.com/
Spamalyser : Spam Tool - http://spamalyser.com/
