I figured out how to make sort work in the Cool listing (and posted the mod), but I'm still having problems trying to get sort to work on the category and link listings
The query:
Priority DESC, isNew, Hits DESC ;
executes properly in the SQL monitor, but in nph_build sub build_category_pages where the category pages are being calculated, the same query returns a very different sort order -- almost random (Though I know it has to be because some other sort order was imposed on top of it).
Anyone figured out how to make this work?
The query:
Code:
Select * from Links Where CategoryID = '9' order by Priority DESC, isNew, Hits DESC ;
executes properly in the SQL monitor, but in nph_build sub build_category_pages where the category pages are being calculated, the same query returns a very different sort order -- almost random (Though I know it has to be because some other sort order was imposed on top of it).
Anyone figured out how to make this work?