[WebDNA] Searching Possible Bug
This WebDNA talk-list message is from 2009
It keeps the original formatting.
numero = 102975
interpreted = N
texte = Hi Hopefully someone can help, To my way of thinking I may have found a little bug, but it may not be, just never noticed this behaviour before. I have a database full of news stories. The DB has a field called HeadlinesSections which is a news category. An individual story could be in multiple categories. I am doing a search for new stories that are either in the Bioenergy or Microgeneration section. I want the results listed by date order so my search is basically... [search db=My.db&woHeadlinesSectionsdatarq=Bioenergy Microgeneration&deHeadlinesDatesort=1&HeadlinesDatetype=date] It works in as much as I get the correct records but because 3 of the records are marked in both sections they always show at the top of the list. It seems to override the date sort and treat the 3 records as more relevant because they have both categories. (hope that makes sense) Is this as expected? Does the wo search override sorts? Is there a way round it without using tables? A sample page is at http://aese.asylumweb.net/Industry_headlines.html although I'm working on it so it may not be there for ever. The top 3 records,.. Measures on renewable... Best green power... IFA is 8000.... are in both categories but should not be at the top as they are older stories. Thanks for any help. ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig ========================================
Associated Messages, from the most recent to the oldest:
Hi Hopefully someone can help, To my way of thinking I may have found a little bug, but it may not be, just never noticed this behaviour before. I have a database full of news stories. The DB has a field called HeadlinesSections which is a news category. An individual story could be in multiple categories. I am doing a search for new stories that are either in the Bioenergy or Microgeneration section. I want the results listed by date order so my search is basically... [search db=My.db&woHeadlinesSectionsdatarq=Bioenergy Microgeneration&deHeadlinesDatesort=1&HeadlinesDatetype=date] It works in as much as I get the correct records but because 3 of the records are marked in both sections they always show at the top of the list. It seems to override the date sort and treat the 3 records as more relevant because they have both categories. (hope that makes sense) Is this as expected? Does the wo search override sorts? Is there a way round it without using tables? A sample page is at http://aese.asylumweb.net/Industry_headlines.html although I'm working on it so it may not be there for ever. The top 3 records,.. Measures on renewable... Best green power... IFA is 8000.... are in both categories but should not be at the top as they are older stories. Thanks for any help. ======================================== Steve Craig - Asylum Interactive Ltd Tel +44 1330 860550 Fax +44 1330 860880 ======================================== http://www.asylumweb.com Email: steve@asylumweb.com Skype: s.craig - iChat: steve.craig ========================================
Steve Craig
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:
Variable prices and Formulas.db (1997)
Sense/Disallow HTML tags during $Append (1997)
[WebDNA] shopping sites and the "old commerce tags" (2012)
I'm Baaaaaaaaaack - Questions! (2000)
raw field names (2001)
Do not truncate a whole word (2004)
Question about replacing words (1998)
Summary layout (1997)
WSDL Wizard (2003)
Multiple radio buttons (1998)
numfound=0 for a search after going into the SSL (2003)
Running _every_ page through WebCat ? (1997)
Virtual Postcards (1998)
WEBDNA-MAMP (Mac OSX 10.3.9) (2006)
authenticating a second user (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Re:What file? (1997)
[WebDNA] Triggers not working (2011)
Change to 5.0 per website licensing (2003)
WebCatalog vs WebDNA (2002)