Re: [exim] domainlist & mysql

トップ ページ
このメッセージを削除
このメッセージに返信
著者: Wakko Warner
日付:  
To: Peter Bowyer
CC: exim-users, Stephen Gran
題目: 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