Hi everyone,
I have modified LinksSQL by adding a priority rating to the links display. Everything works perfectly except for the fact that in searches I cannot seem to sort the order of the display. I have studied the search.pm, search.cgi, and search-ni.cgi modules for insights on how the search results are prioritized by score, yet, I need to add a routine which will sort the outcome on the basis of its priority rating. (By the way, priority ratings are an integer value from 0-9 located in a column called isPriority in the Links table).
I have attempted to change the SQL statements with an "ORDER BY Links.isPriority" clause (where applicable), but, to no avail. I have also attempted to modify the sort commands but with no success either.
How can I access the ranking system of the returned results to add sort parameters? Or, is it possible to wait until the sort is completed and (before the output is created) add a routine to sort by priority?
Has anyone successfully done this hack? I would appreciate any insights you might have to help me solve this problem.
Thanks
I have modified LinksSQL by adding a priority rating to the links display. Everything works perfectly except for the fact that in searches I cannot seem to sort the order of the display. I have studied the search.pm, search.cgi, and search-ni.cgi modules for insights on how the search results are prioritized by score, yet, I need to add a routine which will sort the outcome on the basis of its priority rating. (By the way, priority ratings are an integer value from 0-9 located in a column called isPriority in the Links table).
I have attempted to change the SQL statements with an "ORDER BY Links.isPriority" clause (where applicable), but, to no avail. I have also attempted to modify the sort commands but with no success either.
How can I access the ranking system of the returned results to add sort parameters? Or, is it possible to wait until the sort is completed and (before the output is created) add a routine to sort by priority?
Has anyone successfully done this hack? I would appreciate any insights you might have to help me solve this problem.
Thanks