On Sun, 8 Nov 2020, Mike Tubby via Exim-users wrote:
> Now it looks like I have to use additional look-ups, perhaps something like
> this:
>
> $domain_data = ${lookup mysql{SELECT domains.domain AS domain FROM \
> users LEFT JOIN domains ON users.domain_id=domains.id WHERE \
> users.username='${quote_mysql:$local_part}' AND \
> domains.domain='${quote_mysql:$domain}' AND \
> users.active=1 AND \
> domains.active=1}}
>
> $local_part_data = ${lookup mysql{SELECT users.username AS username FROM
> \
> users LEFT JOIN domains ON users.domain_id=domains.id WHERE \
> users.username='${quote_mysql:$local_part}' AND \
> domains.domain='${quote_mysql:$domain}' AND \
> users.active=1 AND \
> domains.active=1}}
>
> to simply send my 'already known good' keys $local_part and $domain round in
> circles and get the duplicate data (same values) from the database rather
> than use them, directly?
If you do it the way Jeremy suggests, exim will set $local_part_data and
$domain_data for you as side effects of successfully looking up
$local_part and $domain.
--
Andrew C. Aitchison Kendal, UK
andrew@???
