Re: [WebDNA] Searching Possible Bug

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102983
interpreted = N
texte = Hi Steve.... If your using a form to place the search term you might need to encode it... [search db=My.db&woHeadlinesSectionsdatarq=[URL]Bioenergy Microgeneration[/URL]&
[search db=My.db&woHeadlinesSectionsdatarq=[URL][FORMDATA][/URL]& On Jul 20, 2009, at 7:08 AM, Steve Craig wrote: > 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 > ======================================== > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Searching Possible Bug (Donovan Brooke 2009)
  2. Re: [WebDNA] Searching Possible Bug (Govinda 2009)
  3. Re: [WebDNA] Searching Possible Bug (Frank Nordberg 2009)
  4. Re: [WebDNA] Searching Possible Bug (Donovan Brooke 2009)
  5. Re: [WebDNA] Searching Possible Bug (Frank Nordberg 2009)
  6. Re: [WebDNA] Searching Possible Bug (Donovan Brooke 2009)
  7. Re: [WebDNA] Searching Possible Bug (Donovan Brooke 2009)
  8. Re: [WebDNA] Searching Possible Bug (Steve Craig 2009)
  9. Re: [WebDNA] Searching Possible Bug ("Brian Harrington, Broker" 2009)
  10. Re: [WebDNA] Searching Possible Bug (Terry Wilson 2009)
  11. Re: [WebDNA] Searching Possible Bug (Terry Wilson 2009)
  12. Re: [WebDNA] Searching Possible Bug ("Brian Harrington, Broker" 2009)
  13. Re: [WebDNA] Searching Possible Bug (Donovan Brooke 2009)
  14. Re: [WebDNA] Searching Possible Bug ("Brian Harrington, Broker" 2009)
  15. Re: [WebDNA] Searching Possible Bug ("Brian Harrington, Broker" 2009)
  16. Re: [WebDNA] Searching Possible Bug ("Brian Harrington, Broker" 2009)
  17. Re: [WebDNA] Searching Possible Bug (Tom Duke 2009)
  18. Re: [WebDNA] Searching Possible Bug (Steve Craig 2009)
  19. Re: [WebDNA] Searching Possible Bug (Tom Duke 2009)
  20. Re: [WebDNA] Searching Possible Bug (Steve Craig 2009)
  21. Re: [WebDNA] Searching Possible Bug (Paul Willis 2009)
  22. [WebDNA] Searching Possible Bug (Steve Craig 2009)
Hi Steve.... If your using a form to place the search term you might need to encode it... [search db=My.db&woHeadlinesSectionsdatarq=[url]Bioenergy Microgeneration[/URL]&
[search db=My.db&woHeadlinesSectionsdatarq=[url][FORMDATA][/URL]& On Jul 20, 2009, at 7:08 AM, Steve Craig wrote: > 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 > ======================================== > > > > > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > old archives: http://dev.webdna.us/TalkListArchive/ > "Brian Harrington, Broker"

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:

unable to launch acgi in WebCat (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009) [Shell] not relative (2000) Showif, Hideif reverse logic ? (1997) TemplateCacheSize preference (1998) [addlineitems] (1997) WebDNA on Windows questions (2007) Is there an easier way? (1998) minimalist shopping cart. (1997) Webcat interfering with Webstar? (1998) SiteEdit Pro Update Announcement (1997) Bug? (1997) WCS Newbie question (1997) Searching in multiple databases from a form (1999) Re:Webmessage Hyperboard (1998) emailer on Windows Beta 18 (1997) Forcing a NEWCART (1997) READFILE command? (1998) Database (1999) WebMerchant Mac 3.0 beta available (1998)