Re: [Dovecot] Dovecot SQL user_query

2010-05-03 Thread Timo Sirainen
On 4.5.2010, at 2.00, Alex wrote: > Is it possible to setup in dovecot-sql.conf file to run user_query > twice if its first run didn't yield any values. You can have two userdbs pointing to two separate dovecot-sql.conf files with different user_queries.

Re: [Dovecot] Dovecot SQL user_query

2010-05-03 Thread Gabriel Millerd
yes, something akin to this (assuming they are in the same schema) . sorry i cannot be more helpful with the query. the secret is the chance to retrieve multiple results, but limiting those results to one row and having them priroritized mail > users user_query = select mail from (select mail fro

Re: [Dovecot] Dovecot SQL user_query

2010-05-03 Thread Noel Butler
On Mon, 2010-05-03 at 16:00 -0700, Alex wrote: > Hello folkz, > Is it possible to setup in dovecot-sql.conf file to run user_query > twice if its first run didn't yield any values. > And likewise don't proceed with the second run if the first user_query > execution produced the result. > I have t

Re: [Dovecot] Dovecot SQL user_query

2010-05-03 Thread Jerry
On Mon, 03 May 2010 16:00:41 -0700 Alex articulated: > Hello folkz, > Is it possible to setup in dovecot-sql.conf file to run user_query > twice if its first run didn't yield any values. > And likewise don't proceed with the second run if the first user_query > execution produced the result. > I

[Dovecot] Dovecot SQL user_query

2010-05-03 Thread Alex
Hello folkz, Is it possible to setup in dovecot-sql.conf file to run user_query twice if its first run didn't yield any values. And likewise don't proceed with the second run if the first user_query execution produced the result. I have to query two tables which specify there email messages shall