On Nov 27, 2012, at 9:36 AM, Graeme Fowler <[email protected]> wrote: > You need something like this at an appropriate point in your ACL flow, > which sets an ACL variable: > > set acl_m1 = ${lookup mysql{select id,mailhome from usermap where \ > mailname = '${quote_mysql:$local_part}'}{$value}fail} > > then later you can use the "extract" function to query that data as > follows: > > ${extract {mailhome}{$acl_m1}}
Ok, got it.
Does caching not work if you use the SQL in a macro? or does caching only
happen using a ACL variable? I assume the ACL variable that was expanded can
be used in routers and transports?
ie:
Q_USER_HOME = SELECT * FROM \
sp_eximlookup('${quote_pgsql:$domain}', '${quote_pgsql:$local_part}') \
WHERE sp_eximlookup IS NOT NULL LIMIT 1
--
Robert Blayzor
INOC, LLC
[email protected]
http://www.inoc.net/~rblayzor/
smime.p7s
Description: S/MIME cryptographic signature
-- ## List details at https://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/
