Autor: Wakko Warner Data: A: Peter Bowyer CC: exim-users, Stephen Gran Assumpte: Re: [exim] domainlist & mysql
> > No problem. I had asked about it before. Still wish I could do the > > entire query in SQL instead of doing the $sg trick.
>
> The $sg trick is only necessary if you need to construct a colon-separated
> list from an arbitrary set of string arguments. If you just need a simple
> MySQL (or other) lookup, you should use the in-built facility:
>
> domainlist name = mysql;select 1 from domaintable where
> domaincolumn='${quote_mysql:$domain}'
I tried, but since I used the same domainlist as both the senderdomain and
recipient domain, it never worked for me. I just gave up all together and
did that trick.
I don't know if it's possible to concat the rows to 1 line in an sql query.
--
Lab tests show that use of micro$oft causes cancer in lab animals