Re: Newbie search question (between two dates)

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39460
interpreted = N
texte = what was wrong with using the range comparison???on 19/10/01 9:56 AM, Glenn Busbin at gbusbin@home.com wrote:>> I have an event date, and corrosponding description information: eventdate >> and eventdesc respectively. >> >> I need to display all events from today until two weeks from today out of a >> .db called norcalendar.db >> >> [math date]weeks={[date]}+14[/math] >> [search >> db=norcalendar.db&xreventdatedata=[weeks]&mreventdatedata=[date]&eventdatetyp >> e=date&eventdatesort=1] >> [founditems] >> >> >> [eventdate] >> >> >> [eventdesc] >> >> >> [/founditems] >> [/search] >> > > Search for dates greater than or equal to today's date. Once they're found, > hide all dates after today's date plus 14 days. > > Try this and see how it works. It should be close to what you need. > > [search db=norcalendar.db&geEventDatedatarq=[date]] > [founditems] > [hideif [math]{[date]}[/math]>[math]{[date]}+14[/math]] > > [eventdate] > [eventdesc] > > [/hideif] > [/founditems] > [/search] > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Newbie search question (between two dates) (Kenneth Grome 2001)
  2. Re: Newbie search question (between two dates) (Clint Davis 2001)
  3. Re: Newbie search question (between two dates) (Matthew Bohne 2001)
  4. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  5. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  6. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  7. Re: Newbie search question (between two dates) (Brian Fries 2001)
  8. Re: Newbie search question (between two dates) (Brian Fries 2001)
  9. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  10. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  11. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  12. Re: Newbie search question (between two dates) (Glenn Busbin 2001)
  13. Re: Newbie search question (between two dates) (Andrew Simpson 2001)
  14. Newbie search question (between two dates) (Matthew Bohne 2001)
what was wrong with using the range comparison???on 19/10/01 9:56 AM, Glenn Busbin at gbusbin@home.com wrote:>> I have an event date, and corrosponding description information: eventdate >> and eventdesc respectively. >> >> I need to display all events from today until two weeks from today out of a >> .db called norcalendar.db >> >> [math date]weeks={[date]}+14[/math] >> [search >> db=norcalendar.db&xreventdatedata=[weeks]&mreventdatedata=[date]&eventdatetyp >> e=date&eventdatesort=1] >> [founditems] >> >> >> [eventdate] >> >> >> [eventdesc] >> >> >> [/founditems] >> [/search] >> > > Search for dates greater than or equal to today's date. Once they're found, > hide all dates after today's date plus 14 days. > > Try this and see how it works. It should be close to what you need. > > [search db=norcalendar.db&geEventDatedatarq=[date]] > [founditems] > [hideif [math]{[date]}[/math]>[math]{[date]}+14[/math]] > > [eventdate] > [eventdesc] > > [/hideif] > [/founditems] > [/search] > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Andrew Simpson

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:

Help! WebCat2 bug (1997) FAX orders (1996) Re:Non-technical messages ... (1997) French characters in variables (2001) 'does not contain' operator needed ... (1997) Search in 2 or more catalogs (1997) [WebDNA] path traversal (2020) RE: protect tag on NT (1997) Empty Shopping Carts (1998) Demo math questions (2000) MacAuthorize order data fields WAS:How To question... (1997) Changing the value assigned to a formvariable (2000) SSL (1998) How can I record purchases to a database? (1998) Searching multiple fields (1997) unable to launch acgi in WebCat (1997) [searchString] (1997) MacAuthorize order data fields WAS:How To question... (1997) Browser Caching (2003) WebCatalog for Dummies part 2 (2000)