Mike Cardwell
Fri, 26 Feb 2010 14:01:41 -0800
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/ -- ## List details at http://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/