On Fri, Mar 20, 2009 at 03:59:05PM +0100, Sebastian Chociwski wrote:
> query = SELECT email FROM users WHERE email='%s'
> AND mailactiv='1'
Is the "mailactiv" column integer-valued or string-valued?
> NOT WORK.
You really should report output from tests with "postmap -q". "NOT WORK"
is rather useless.
> query = SELECT email FROM users WHERE email='%s'
> additional_conditions = AND mailactiv = '1'
Of course, "additional_conditions" is not used with new "query =" syntax,
only with the the obsolete "table =" syntax.
> query = SELECT email FROM users WHERE email='%s' AND mailactiv='1'
Equivalent to the first.
> query = SELECT email FROM users WHERE mailactiv='1' AND email='%s'
Ditto, the order of constraints in SQL is not significant.
> SETS THE WHOLE SYSTEM OUT OF ORDER.
How are we supposed to know what "sets the whole system out of order"
means?
--
Viktor.
Disclaimer: off-list followups get on-list replies or get ignored.
Please do not ignore the "Reply-To" header.
To unsubscribe from the postfix-users list, visit
http://www.postfix.org/lists.html or click the link below:
<mailto:[email protected]?body=unsubscribe%20postfix-users>
If my response solves your problem, the best way to thank me is to not
send an "it worked, thanks" follow-up. If you must respond, please put
"It worked, thanks" in the "Subject" so I can delete these quickly.
