Re: [exim] domainlist & mysql

Αρχική Σελίδα
Delete this message
Reply to this message
Συντάκτης: Wakko Warner
Ημερομηνία:  
Προς: Peter Bowyer
Υ/ο: 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