[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:
Another IfThenElse question.. (2003)
SSL and reg web*L and reg web* (1997)
Newbie Help (2003)
Banner Ad example (Typhoon) and WebCatalog (1997)
webcat2b12 CGI -- Date comparisons (1997)
How do I specify a & character in Grep? (2000)
Prices Dropped (1998)
Restoring textarea stored in header (1998)
Format 1.15 to 1:15:00 or 01:15:00 (2002)
show all problem (1997)
Re:PCS Customer submissions ? (1997)
Languages (1997)
OT: Version Control (2007)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[WebDNA] Emailer Issue (2009)
Apache won't load after v5 install (2003)
Accented chars and emailer (1998)
Re:Emailer tracking (1997)
Multiple fields on 1 input (1997)
BR (1997)