Order by Date problem

[scott.gray]

The following query seems to ignore the order by clause.

<sql skip=$skip max=$max "
select Datedis, id, Ettitle, Art_title, Atitle, Titledis, Wordcount, Rec_type, SubProd
from BNI
where Art_title\Atitle\... like 'computer'
and Art_title\Atitle\... like '@0 tandem fault'
order by Date desc">
</sql>

There is a compound index on Art_title\Atitle\..., Date.
There is an inverted descending index on Date as well.

Texis Version 3.0.947525271.

Thanks
Scott

[John]

It looks as if that might happen with that version when there are several portions in the where clause, and the the compound index. That version is about three years old, and upgrading to a newer version should solve that.