using temporary field exception

[Ruslan Zasukhin]

On 3/2/05 2:59 PM, "jda" <jda at his.com> wrote:

>>> 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

Put this as BUG for Ivan.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------