numero = 102986
interpreted = N
texte = I don't know if this was just an example or what, but when using form elements, wrap webdna in [input]tags, and use quote marks, like so: > The quotes protect from things like spaces (in your example, the value would resolve to simply value=Bioenergy) and the input protects from things like carriage returns, which would do the same thing as a space, quote marks, ampersands, etc. It's kinda like using [url] when writing into a db. Terry >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/ >> > >--------------------------------------------------------- >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/ -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Associated Messages, from the most recent to the oldest:
I don't know if this was just an example or what, but when using form elements, wrap webdna in [input]tags, and use quote marks, like so: >[input][fieldname][/input]"> The quotes protect from things like spaces (in your example, the value would resolve to simply value=Bioenergy) and the input protects from things like carriage returns, which would do the same thing as a space, quote marks, ampersands, etc. It's kinda like using [url] when writing into a db. Terry >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/ >> > >--------------------------------------------------------- >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/ -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure.
Terry Wilson
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...