Re: [WebDNA] reverse rank=off
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 100413
interpreted = N
texte = Palle, I believe the from=end was just a suggestion for a new feature. I have always found that the time taken to try to make a workaround is usually much greater than just sitting down and fixing something. That is, I would just add a new field and populate it with a serial number, then you;ll never have to worry about it again, or write huge temporary tables or anything. Terry >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) > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
Palle, I believe the from=end was just a suggestion for a new feature. I have always found that the time taken to try to make a workaround is usually much greater than just sitting down and fixing something. That is, I would just add a new field and populate it with a serial number, then you;ll never have to worry about it again, or write huge temporary tables or anything. Terry >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) > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
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:
Redirect frame targets (1998)
Updating fields from different platforms (1998)
normal users.db calls ... (1998)
debit cards and checksum (1998)
Rendering out a page-test results (1997)
setting username and password using a form. (2000)
Problem with CC problem ? (1997)
Frames and cart values (1998)
Keyword search (2004)
Development terminated. (1998)
Problem with Shared POP script (2003)
problem with applets embedded in tpl files (1997)
appleshare/ip (1997)
ANN: Strategic Partnership with BuyStream Announced. (2000)
MacAuthorize and WebMerchant (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Last Day of the Month (2005)
AddLineitems - 100 Item Limit? (2002)
[WebDNA] Successful, working WebDNA7/CentOS install? (2013)
Rephrased: Web Site Stats (2002)