Re: Newbie search question (between two dates)

This WebDNA talk-list message is from

2001


It keeps the original formatting.
numero = 39459
interpreted = N
texte = >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]&eventdatetype=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/ 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)
>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]&eventdatetype=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/ Glenn Busbin

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:

Sending E-mail (1997) A little syntax help (1997) Non-repeating Random Numbers - CORRECTION (2002) WebCat2.0 [format thousands .0f] no go (1997) Sandboxes & Kitty Litter trays (2003) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) Emailer port change (1997) [ShowNext] (1997) Unix DB Permission Error (2002) PCS Frames (1997) Explorer 3.0 (1997) why .HTML pages no processing? (2000) What is WebDNA (1997) Math with Time (1997) multi-paragraph fields (1997) Email SMTP Error 411 (2006) Security Question (1997) simple [convertChars] Q (2000) How can I record purchases to a database? (1998) Re:Virtual hosting and webcatNT (1997)