On Fri, Jul 8, 2005, ""Igor Olemskoi"" <[EMAIL PROTECTED]> said:
>> Igor, the query we use in the code now is: >> SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = >> lower('[EMAIL PROTECTED]') AND lower(alias) <> lower(deliver_to) >> What output do you get for: >> SELECT alias, deliver_to FROM dbmail_aliases WHERE >> lower(alias) = lower('[EMAIL PROTECTED]') > > Current database: dbmail > > mysql> SELECT alias, deliver_to FROM dbmail_aliases WHERE > -> lower(alias) = lower('[EMAIL PROTECTED]') > -> ; > Empty set (0.00 sec) > > mysql> SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = > -> lower('[EMAIL PROTECTED]') AND lower(alias) <> > lower(deliver_to); > Empty set (0.00 sec) So what's the problem again? This address has neither an alias nor a username; hence no deliveries go to it. Did I miss something? Aaron