On Mon, Mar 17, 2014 at 02:28:02AM +0100, Sergei wrote:
> On Sunday 16 March 2014 21:19:24 bluethu...@jokefire.com wrote:
> > user=mail
> > password=secret
> > dbname=maildb
> > table=domains
> > select_field=domain
> > where_field=domain
> > hosts=127.0.0.1
> > additional_conditions = and enabled = 10
>
> I am not familiar with this syntax. I use the following:
>
> user = mail
> password = secret
> hosts = 127.0.0.1
> dbname = maildb
> query = SELECT * FROM domains WHERE domain='%s'
Better:
query = SELECT domain FROM domains WHERE domain='%s' AND enabled = 10
there is no need to select all the columns. (No idea what the
significance of "enabled = 10" is, except that seemingly this is
what the OP wants or perhaps it is the reason why no results are
returned).
--
Viktor.
