Order by Date problem
Posted: Fri Jan 02, 2004 11:10 am
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
<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