| Author |
 Topic  |
|
|
Aaron S.
Average Member
USA
985 Posts |
 Posted - 28 March 2002 : 18:43:58
|
In the dropdown for Search Forum: on search.asp... the forums are listed in no particular order (and therefore look unordered).
I'm not sure what the right order should be... probably F_SUBJECT but it shouldn't be left to the whim of SQL SERVER (who will always choose something funky).
 |
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 28 March 2002 : 19:27:24
|
That select is in the order that the forums are on default.asp (At liest it is for me)
However the results are organized by forum in no particular order.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 28 March 2002 : 19:28:25
|
They are in the same order as specified by the admin. First by order of category, then by order of forum.
Nikkol |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 March 2002 : 19:35:08
|
actually it's ordered by FORUM_TOPICS.FORUM_ID and then by FORUM_TOPICS.T_LAST_POST.
the search is already pretty database intensive, if we also pull data from the FORUM_CATEGORY and FORUM_FORUM tables just to get the order set by the Admin, is it really worth the extra overhead? Right now the only tables used by search.asp are FORUM_TOPICS, FORUM_REPLY & FORUM_MEMBERS (FORUM_A_TOPICS & FORUM_A_REPLY when searching the archive). |
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 28 March 2002 : 19:38:13
|
he means the list of forums in the dropdown, not the search results.
The dropdown query has no order by clause
|
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 28 March 2002 : 19:42:02
|
Oosp, I guess it doesn't in 3.3.03, I was looking at the search.asp here on this site.
Which brings up another question. How difficult would it be to make a 'search by cat' select box?
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 March 2002 : 19:42:54
|
quote:
he means the list of forums in the dropdown, not the search results.
The dropdown query has no order by clause
ahh.. ok. That's easy enough to fix. I think it was on my to do list at one time. |
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 28 March 2002 : 19:43:51
|
quote:
Which brings up another question. How difficult would it be to make a 'search by cat' select box?
the search page that Gor had coded did just that. It searched by Category instead of by individual forums. |
|
|
|
Nathan
Help Moderator
USA
7664 Posts |
Posted - 28 March 2002 : 19:47:57
|
I could be benificial to allow either option.
For example when I am trying to find out if I'm posting a bug that has already been posted I end up searching the bugs (open) forum, then go back and search the bugs (closed) forum.
Nathan Bales - Romans 15:13
----------------------------------
Snitz Exchange | Do's and Dont's |
|
|
|
Aaron S.
Average Member
USA
985 Posts |
Posted - 28 March 2002 : 23:33:11
|
I think Category would be of value also...
BTW: for those that want it, here is the sql call to sort Forums in the same order as they are on the main page.
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_SUBJECT"
strSql = strSql & " FROM " & strTablePrefix & "FORUM, " & strTablePrefix & "CATEGORY"
strSql = strSql & " WHERE " & strTablePrefix & "CATEGORY.CAT_ID = " & strTablePrefix & "FORUM.CAT_ID"
strSql = strSql & " ORDER BY " & strTablePrefix & "CATEGORY.CAT_ORDER, " & strTablePrefix & "FORUM.F_ORDER"
It should go somewhere around line 392.
|
|
|
| |
Topic |
|
Topic Locked
