[search =db=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy =Microgeneration&HeadlinesDatesort=3D1&HeadlinesDatesdir=3DDE&HeadlinesDatetype=3Ddate]
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/
[search =db=3DMy.db&woHeadlinesSectionsdatarq=3DBioenergy =Microgeneration&HeadlinesDatesort=3D1&HeadlinesDatesdir=3DDE&HeadlinesDatetype=3Ddate]
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/
DOWNLOAD WEBDNA NOW!
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...