Order by Date problem

Post Reply
scott.gray
Posts: 15
Joined: Fri Jul 12, 2002 9:25 am

Order by Date problem

Post by 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
Post Reply