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:
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)