Hi Sam,
Please help me understand...
>> You want the maildir field to contain something like:
>> >> IF(STRCMP('$(service)', 'courier') == 0, users.delivery
, >> '')
>> > > I'm not quite sure what you mean. The maildir field can
> be conditional like that? I'm confused, sorry! :-/
You are using a custom SELECT query. Any valid SQL, as long as it returns the requisite number of fields, may be used.
I was wondering what this was: IF(STRCMP('$(service)', 'courier') == 0, users.delivery, '')
I mean, does that go into authmysqlrc? If so, in what section?
Your previous post indicated that you're using the custom query. So, the above MySQL-specific SQL would be used in place of the maildir field, which you currently always return as a fixed, empty string.
Does it mean that the SELECT query can only return one of either MAILDIR or DEFAULTDELIVERY fields? and if so, it means to return MAILDIR for imap/pop, but DEFALUTDELIVERY for courier?
You got it. Unfortunately, for now this has to be the way it's done due to legacy issues.
pgp00000.pgp
Description: PGP signature
