MySQL will return a result of 1 if you use such a select query, as Nico
stated. So I think the SQL query to return a proper $local_part@$domain value
would be different from this one.
On Wednesday 31 December 2003 17:28, Nico Erfurth wrote:
> ISP List wrote:
> > Thanks for responding.
> >
> > What does the "1" signify in the SELECT statement (or is that just a
> > typo)? I assumed that it would be something like:
> >
> > SELECT from USERS where EMAIL='$local_part@$domain'
>
> ^ This one misses the fields.
>
> > ..and if it returned no value, then the condition has been met, and the
> > "user unknown" error would be returned. If a value was returned from the
> > SELECT statement, the ACL should be passed by. Am I correct?
>
> The "command-style" lookups (lookup;) will return true when a value is
> returned, it does not care about the value itself. So, when a row
> matches, just 1 will be returned, instead of any extracted data.
>
> Nico
--
Christopher Chaduka
Technical Department
M-Web Zimbabwe (Pvt) Ltd
http://www.mweb.co.zw
