Добрый день Paul,
Tuesday, October 19, 2004, 1:21:30 PM, you wrote:
Paul J Stevens> Anton Nekhoroshikh wrote:
>>
>> Paul J Stevens> Oct 18 16:58:20 com0
>> Paul J Stevens> dbmail/smtp[19957]: dboracle.c,db_query: [SELECT
>> Paul J Stevens> deliver_to
>> Paul J Stevens> FROM dbmail_aliases
>> Paul J Stevens> WHERE lower(alias) = lower('[EMAIL PROTECTED]')]
>> Paul J Stevens> Oct 18 16:58:20 com0
>> Paul J Stevens> dbmail/smtp[19957]: dboracle.c,db_num_rows: cannot
>> Paul J Stevens> fetch result
>>
>> Paul J Stevens> this query shouldn't fail.
>>
>> SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('[EMAIL
>> PROTECTED]')
>> [EMAIL PROTECTED] alias to [EMAIL PROTECTED]
Paul J Stevens> ergo, a bug in the oracle driver.
Nonsense full;) the everything else works truly!!!
The old version works truly!!!
SELECT deliver_to
FROM dbmail_aliases
WHERE lower(alias) = lower('[EMAIL PROTECTED]')
Cannot return anything as in base is alias for [EMAIL PROTECTED], instead
of for [EMAIL PROTECTED] !
--
С уважением,
Anton Nekhoroshikh
Руководитель проекта
отдела сложных телекоммуникационных систем
тел. (095) 363 3 310
факс (095) 363 3 310
e-mail: [EMAIL PROTECTED]
http://www.310.ru
