| Author |
 Topic  |
|
|
Panhandler
Average Member
USA
783 Posts |
 Posted - 18 November 2006 : 09:37:49
|
Is there a recommended way to structure a topic so that it shows up first in the Snitz Search?
I have an important topic on "Slide Repair" (its a mechanism used in RV campers). But the term "slide" has been used so frequently that my important topic is buried in search results for "slide".
|
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 18 November 2006 : 09:40:32
|
| no |
 |
|
|
Shaggy
Support Moderator
Ireland
6780 Posts |
Posted - 20 November 2006 : 04:25:44
|
Topics in search.asp are sorted by last post date as they are on other forum pages. If you wanted, though, you could modify that so that it sorted by T_STICKY first so that all sticky topics would be the first to be displayed in a search of the relevabnt forum. Alternatively, you could hard code in a link to the topic after checking for the presence of the word "slide" in the search terms entered.
|
 Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.” |
|
|
|
Panhandler
Average Member
USA
783 Posts |
Posted - 20 November 2006 : 10:30:23
|
quote:
Originally posted by Shaggy
Topics in search.asp are sorted by last post date as they are on other forum pages. If you wanted, though, you could modify that so that it sorted by T_STICKY first so that all sticky topics would be the first to be displayed in a search of the relevabnt forum. . .
Now THAT's a good idea. I don't know how to accomplish it, but it's a good idea.
In fact, I had made the topic a sticky, but it was still burried in the search results.
Maybe it can be added to the "wish list" for Snitz. |
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 20 November 2006 : 10:41:42
|
to make it order the results differently, you will need to edit the query code in search.asp
look for the following line
strSql4 = " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
should be around line 294 and change it to
strSql4 = " ORDER BY T.T_STICKY DESC, C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
that should make sticky topics appear at the top of the list |
|
|
|
RArch
Junior Member
United Kingdom
103 Posts |
Posted - 20 November 2006 : 12:32:59
|
quote:
Originally posted by HuwR
to make it order the results differently, you will need to edit the query code in search.asp
look for the following line
strSql4 = " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
should be around line 294 and change it to
strSql4 = " ORDER BY T.T_STICKY DESC, C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
that should make sticky topics appear at the top of the ist
Yeap, it sure did for me.
Thanks
|
|
|
|
Panhandler
Average Member
USA
783 Posts |
Posted - 20 November 2006 : 13:46:35
|
quote:
Originally posted by HuwR
to make it order the results differently, you will need to edit the query code in search.asp
look for the following line
strSql4 = " ORDER BY C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
should be around line 294 and change it to
strSql4 = " ORDER BY T.T_STICKY DESC, C.CAT_ORDER, C.CAT_NAME, F.F_ORDER, F.F_SUBJECT, T.T_LAST_POST DESC"
that should make sticky topics appear at the top of the list
Yup. . .that did it for me too.
The important topic in the "Sticky" now shows up where before it didn't.
Thank you for the helpful little mod.
|
"5-in-1 Snitz Common Expansion Pack" - five popular mods packaged for easy install
". . .on a mote of dust, suspended in a sunbeam. . ."
HarborClassifieds
Support Snitz Forums
|
|
|
|
TonyB7
Junior Member
USA
267 Posts |
Posted - 22 November 2006 : 14:42:43
|
Hm. I wonder why this doesn't work for me? Access db, lots of mods (the word 'DISTINCT' only appears in one Poll Mod file).
quote:
Microsoft JET Database Engine error '80004005'
ORDER BY clause (T.T_STICKY) conflicts with DISTINCT.
/forum/search.asp, line 355
|
|
|
|
HuwR
Forum Admin
United Kingdom
20600 Posts |
Posted - 22 November 2006 : 18:59:15
|
| have you modified your search.asp ? line 355 has nothing to do with the order clause of the query |
|
|
|
TonyB7
Junior Member
USA
267 Posts |
|
| |
Topic |
|
Topic Locked
