IMHO, you have to test the incomming mail against a list and that is what
this query is doning:
relay_domains = mysql;select Domain from Domains where Domain="$key"
robert
PS: maby it's better quouting this...
relay_domains = mysql;select Domain from Domains where
Domain='${quote_mysql::$key}'
On Fri, 28 Jul 2000, Nigel Cass wrote:
> Surely if we're after setting relay domains and the table holds a list
> of all of them............
>
> Our query is just.....
>
> Select * FROM Domains
>
> we don't need a WHERE clause because we want them all anyway.....
>
> Nige.
>
>
> Philip Hazel wrote:
> >
> > On Thu, 13 Jul 2000, Nancy Pettigrew wrote:
> >
> > > Is this syntactically correct? (The Domains table just has a list of all
> > > the domains to relay for...)
> > >
> > > relay_domains = ${lookup mysql{select Domain from Domains}{$value}fail}
> >
> > No. What you want is
> >
> > relay_domains = mysql;select Domain from Domains
> >
> > However, the query isn't right; it should be looking up the domain you
> > are interested in. Try
> >
> > relay_domains = mysql;select Domain from Domains where Domain="$key"
> >
> > The value of $key is the name of the domain you are testing.
> >
> > --
> > Philip Hazel University of Cambridge Computing Service,
> > ph10@??? Cambridge, England. Phone: +44 1223 334714.
> >
> > --
> > ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
> --
> ## List details at http://www.exim.org/mailman/listinfo/exim-users Exim details at http://www.exim.org/ ##
>
---
di. robert rotman inode.graz
phone -> ++43-(0)316 813141 ++43-(0)316 818600/15 <- fax
rotman@??? http://www.graz.inode.at/
--
this letter was written on recycled bytes used by deleted mail.
