Re: [WebDNA] Searching Possible Bug

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 102982
interpreted = N
texte = --Apple-Mail-10--795878451 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit sorry... this is correct (i forgot the s... it's sdir!) > [search db=My.db&woHeadlinesSectionsdatarq=Bioenergy > Microgeneration > &HeadlinesDatesort=1&HeadlinesDatesdir=DE&HeadlinesDatetype=date] 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/ > --Apple-Mail-10--795878451 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable sorry... this is correct (i = forgot the s... it's sdir!)

[search = db=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy = Microgeneration&HeadlinesDatesort=3D1&HeadlinesDatesdir=3DDE&HeadlinesDatetype=3Ddate]


<= /div>
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=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy = Microgeneration&deHeadlinesDatesort=3D1&HeadlinesDatetype=3Ddate]<= br>
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.asy= lumweb.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.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Steve Craig - = Asylum Interactive Ltd
Tel +44 1330 860550 Fax +44 1330 = 860880
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
http://www.asylumweb.com
Email: = steve@asylumweb.com
Skype: s.craig - iChat: = steve.craig
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D




---------------------------------------------------------
Thi= s message is sent to you because you are subscribed to
the mailing = list <talk@webdna.us>.
To unsubscribe, E-mail to: = <talk-leave@webdna.us>
archives: = http://mail.webdna.us/list/talk@webdna.us
old archives: = http://dev.webdna.us/TalkListArchive/


=
= --Apple-Mail-10--795878451-- 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)
--Apple-Mail-10--795878451 Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit sorry... this is correct (i forgot the s... it's sdir!) > [search db=My.db&woHeadlinesSectionsdatarq=Bioenergy > Microgeneration > &HeadlinesDatesort=1&HeadlinesDatesdir=DE&HeadlinesDatetype=date] 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/ > --Apple-Mail-10--795878451 Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable sorry... this is correct (i = forgot the s... it's sdir!)

[search = db=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy = Microgeneration&HeadlinesDatesort=3D1&HeadlinesDatesdir=3DDE&HeadlinesDatetype=3Ddate]


<= /div>
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=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy = Microgeneration&deHeadlinesDatesort=3D1&HeadlinesDatetype=3Ddate]<= br>
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.asy= lumweb.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.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Steve Craig - = Asylum Interactive Ltd
Tel +44 1330 860550 Fax +44 1330 = 860880
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
http://www.asylumweb.com
Email: = steve@asylumweb.com
Skype: s.craig - iChat: = steve.craig
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D




---------------------------------------------------------
Thi= s message is sent to you because you are subscribed to
the mailing = list <talk@webdna.us>.
To unsubscribe, E-mail to: = <talk-leave@webdna.us>
archives: = http://mail.webdna.us/list/talk@webdna.us
old archives: = http://dev.webdna.us/TalkListArchive/


=
= --Apple-Mail-10--795878451-- "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:

Sort Order on a page search (1997) More Applescript (1997) search same field twice??? (1999) LookUp Tag (1997) WebCat2 beta 11 - new prefs ... (1997) Test (2002) Never ending problem.... (2000) Searching multiple fields from one form field (1997) Auto entering Friday's date in a field (2002) Help! Missing [showif] or [hideif] (2000) Command=Showcart? (2000) Web Logs (1998) [searchString] (1997) Date stamp and purging (1998) For those of you not on the WebCatalog Beta... (1997) Resume Catalog ? (1997) [Sum] function? (1997) Using Plug-In while running 1.6.1 (1997) apparent variable variable display? (2000) Multiple fields on 1 input (1997)