using temporary field exception

[jda]

>>Jon, in 2.0 you can do what you want using SQL itself:
>>
>>     select *, IFNULL(authors, IFNULL(editors,title)) as 'ff'
>>     from thereferences
>>     where hit > 0
>>     ORDER BY ff, thedate
>>
>>Please try this also
>>
>
>I like this much better! But it gives me the same error: field "60" 
>does not exist.
>
>Jon

OK, more info:

select *,IFNULL(authors, IFNULL(editors,title)) as 'ff' from 
thereferences where hit>0

works. But

select *,IFNULL(authors, IFNULL(editors,title)) as 'ff' from 
thereferences where hit>0 ORDER BY ff

give the error field "60" not found.

So it's a problem with ORDER BY

Jon