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:
File upload woes (1998)
Getting Total Quantity (1997)
WebCat2 beta 11 - new prefs ... (1997)
Nested vs conditional (1997)
using webdna to determine pixel parameters (2000)
passing cart value (2003)
Help HTML reader (1999)
dbQuickView 2.0 - something related (2005)
Upgrade to WebCat2 from Commerce Lite (1997)
Nesting format tags (1997)
WebCat2 beta 11 - new prefs ... (1997)
File Upload (1997)
[WebDNA] special chars (2009)
WSDL Wizard (2003)
taxTotal, grandTotal (1997)
Newbie questions (1999)
japanese characters (1997)
transferring values (1998)
Interfacing WebMerchant to www.fedex.com (1997)
WebCommerce: Folder organization ? (1997)