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:
Security Tip (1996)
WebDNA Server Not Running (2005)
WebTen? (1997)
2.0Beta Command Ref (can't find this instruction) (1997)
Multiple instances of database (2003)
anyone moved to v6? (2004)
Browser frames and URLs in the Location field (2004)
Update quantity (2000)
emailer 150 (1997)
OT - AppleScript Request (2004)
CORRECTION... Exporting a blank record (2000)
Linux Beta4 Problem (2000)
REDIRECT MULTIPLE RESULTS (2000)
Re:2nd WebCatalog2 Feature Request (1996)
Bug Report, maybe (1997)
[WebDNA] crashes are back (2008)
List Archives (2000)
Formulas.db + Users.db (1997)
WCS Newbie question (1997)
Redirect from Domain1 to Domain2 (2004)