Hi, is this a bug or not?
I'm using MySQL 3.23.49!
When I want to use this:
SELECT
CASE
WHEN hmContactGroup.Id = 1 THEN CONCAT(hmContact.FullName, ' ',
hmContact.CountryId)
ELSE COALESCE(hmContact.DjName, hmContact.FullName)
END AS ContactName
FROM
hmContact,
hmContact_ContactGroup,
hmContactGroup
WHERE
(hmContactGroup.Id = 1) AND
(hmContactGroup.ShowLinkGroup = 'Y') AND
(hmContact_ContactGroup.ContactGroupId = hmContactGroup.Id) AND
(hmContact.Id = hmContact_ContactGroup.ContactId) AND
(hmContact.Website IS NOT NULL)
ORDER BY
UPPER(ContactName) ASC
it will return with
ERROR 1054: Unknown column 'ContactName' in 'order clause'
Without UPPER in the ORDER BY it works.
In ORACLE 8i it works ...
BEST REGARDS,
Robert GRAF
Vienna, AUSTRIA
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
