Re: [WebDNA] reverse rank=off
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100407
interpreted = N
texte = I hear you TC but, I just wanted to rescue one of my old DB's which do not have a unique key nor does it include the date (look'ed-up from another DB). It sound logical to me to use the rank=off to display it as it was written to the DB. It sound logical to me that I could reverse this order with some functionality within WebDNA. It's OK with me that WebDNA is not capable of doing this to help me out here ;) Unfortunately, I think I need to rescue this good old DB by providing it with a unique serial. Anyways... Thanks all. Palle On 28/07/2008, at 20.17, Toby Cox wrote: > Webdna isn't really set up to do what you want to do. > > You are asking to have the results ordered by most relevant, but > also my most recent. > > if you want it by most relevant, then the "rank=off" in your code is > fine > > if you want it ordered by date, then "deskusort=1" would do > > if you want it ordered by most relevant, but grouped by year then > you could do the following: > > [search db=/forum/db/ > l4text.db&wsl4_txt1data=[forumsearch]&deyearsort=1&yearsumm=T] > [!][/!] > [founditems] >
[year]
> [search db=/forum/db/ > l4text > .db > &wsl4_txt1datarq > = > [forumsearch > ]&eqyeardatarq > =[year]&max=[_searchvalue]&rank=off&startat=[start]&allreqd=T] > [founditems] > search results here... > [/founditems] > [/search] > [/founditems] > [/search] > > > However, from a usability point of view, I think I would find that > confusing - I either want most relevant or I want most recent, not a > mish mash of the two. > > Why not sort by either rank or date, and then give users the choice > to reorder their results with a drop down saying order by: date or > relevance > > > > > TC > > > > > On 28 Jul 2008, at 18:46, Palle Bo Nielsen wrote: > >> Can't make it work... >> >> My search context now looks like this >> >> [search db=/forum/db/ >> l4text >> .db >> &wsl4_txt1data >> = >> [forumsearch >> ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] >> >> The result from execution of the search context look like this... >> >> http://www.macnyt.dk/forum/?page=forumsearch_result >> >> If you eg. search for the word powerpalle it should show the result >> from 2008 first and the 2007 and 2006... sorry about the speed. >> More than 400.000 records (user entries) in this forum database. >> >> Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 >> >> Remember it's euro date format. >> >> Hope for help >> >> Palle >> >> >> >> >> On 28/07/2008, at 04.31, Gary Krockover wrote: >> >>> I believe it should be: >>> >>> &rank=off&from=end >>> >>> :) >>> >>> GJK >>> >>> At 02:15 PM 7/27/2008, you wrote: >>>> Hi all, >>>> >>>> In a search context you are able to set rank=off which can give a >>>> result where the first record ever written in the DB gets first and >>>> the last record ends out at the end. >>>> >>>> How can I reverse this? >>>> >>>> Unfortunately the DB in this scenario does not have a unique >>>> index... >> >> Venlig hilsen >> >> Palle Bo Nielsen >> (PowerPalle) >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list
. > To unsubscribe, E-mail to: > Venlig hilsen Palle Bo Nielsen (PowerPalle)
Associated Messages, from the most recent to the oldest:
I hear you TC but, I just wanted to rescue one of my old DB's which do not have a unique key nor does it include the date (look'ed-up from another DB). It sound logical to me to use the rank=off to display it as it was written to the DB. It sound logical to me that I could reverse this order with some functionality within WebDNA. It's OK with me that WebDNA is not capable of doing this to help me out here ;) Unfortunately, I think I need to rescue this good old DB by providing it with a unique serial. Anyways... Thanks all. Palle On 28/07/2008, at 20.17, Toby Cox wrote: > Webdna isn't really set up to do what you want to do. > > You are asking to have the results ordered by most relevant, but > also my most recent. > > if you want it by most relevant, then the "rank=off" in your code is > fine > > if you want it ordered by date, then "deskusort=1" would do > > if you want it ordered by most relevant, but grouped by year then > you could do the following: > > [search db=/forum/db/ > l4text.db&wsl4_txt1data=[forumsearch]&deyearsort=1&yearsumm=T] > [!][/!] > [founditems] > [year]
> [search db=/forum/db/ > l4text > .db > &wsl4_txt1datarq > = > [forumsearch > ]&eqyeardatarq > =[year]&max=[_searchvalue]&rank=off&startat=[start]&allreqd=T] > [founditems] > search results here... > [/founditems] > [/search] > [/founditems] > [/search] > > > However, from a usability point of view, I think I would find that > confusing - I either want most relevant or I want most recent, not a > mish mash of the two. > > Why not sort by either rank or date, and then give users the choice > to reorder their results with a drop down saying order by: date or > relevance > > > > > TC > > > > > On 28 Jul 2008, at 18:46, Palle Bo Nielsen wrote: > >> Can't make it work... >> >> My search context now looks like this >> >> [search db=/forum/db/ >> l4text >> .db >> &wsl4_txt1data >> = >> [forumsearch >> ]&max=[_searchvalue]&rank=off&from=end&startat=[start]&allreqd=T] >> >> The result from execution of the search context look like this... >> >> http://www.macnyt.dk/forum/?page=forumsearch_result >> >> If you eg. search for the word powerpalle it should show the result >> from 2008 first and the 2007 and 2006... sorry about the speed. >> More than 400.000 records (user entries) in this forum database. >> >> Anyway. I want the result in this order >>> 2008 >>> 2007 >>> 2006 >> >> Remember it's euro date format. >> >> Hope for help >> >> Palle >> >> >> >> >> On 28/07/2008, at 04.31, Gary Krockover wrote: >> >>> I believe it should be: >>> >>> &rank=off&from=end >>> >>> :) >>> >>> GJK >>> >>> At 02:15 PM 7/27/2008, you wrote: >>>> Hi all, >>>> >>>> In a search context you are able to set rank=off which can give a >>>> result where the first record ever written in the DB gets first and >>>> the last record ends out at the end. >>>> >>>> How can I reverse this? >>>> >>>> Unfortunately the DB in this scenario does not have a unique >>>> index... >> >> Venlig hilsen >> >> Palle Bo Nielsen >> (PowerPalle) >> > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > Venlig hilsen Palle Bo Nielsen (PowerPalle)
Palle Bo Nielsen
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
email problem (2005)
How to verify email address (1997)
Weird Math and SV Bad News (1997)
Is [variable] a Number? (2007)
Sales Tax db (1998)
Webcatalog error, Plug-in for Webstar (1996)
Help name our technology! (1997)
Bug or syntax error on my part? (1997)
Users.db [encrypt seed=????] (1998)
[WebDNA] Databases not staying open (2010)
[SHOWNEXT] Examples (1997)
Encrypted links ... (2000)
Locking up with WebCatalog... (1997)
[URL] around a [sendmail] recipient? - SEARCHING: command vs. context (2000)
db extesion (2000)
Showif Context combined with Search (1997)
Siteedit (1999)
Off-topic: Cheap hosting (but not webdna) ... (2002)
Q: writefile and uploads. (1998)
Sort Order on a page search (1997)