> 
> ----- Original Message ----- 
> From: "Craig Jackson" <[EMAIL PROTECTED]>
> To: <[email protected]>
> Sent: Thursday, October 25, 2007 7:42 AM
> Subject: [exim] domainlist mysql lookup not working
> 
> 
> >I have created a named list populated by a mysql lookup in 
> the general
> > section like this:
> >
> > BLOCK_REGEX = SELECT regex_domain FROM whitelist WHERE 
> regex_domain !=
> > '' AND block = '-1'
> >
> 
> BLOCK_REGEX = SELECT DISTINCT regex_domain FROM whitelist 
> WHERE regex_domain 
> !='' AND block ='-1';
> 
> Thanks
> 


I got it working like this:

domainlist dom_regex = ${sg {${lookup mysql{BLOCK_REGEX}}}{\n}{:}}


I know there's an easier way, but so be it.

Thanks, Craig, for your response.

-- 
## 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/

Reply via email to