Re: dates as search criteria

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28637
interpreted = N
texte = >I won't forget the 'rule', ...but I AM successfully using this search to find records in a date range and I do believe I got the technique straight from the docs... > >[Search db=some.db >&mrDayOrdereddatarq=[mrDayOrdereddatarq] >&xrDayOrdereddatarq=[xrDayOrdereddatarq] >&max=[max] >&startat=[start] >&DayOrderedtype=date >&TimeOrderedtype=time >&DayOrderedsort=1 >&TimeOrderedsort=2 >&DayOrderedsdir=de >&TimeOrderedsdir=de] > >I don't mean to argue I just would like to know what really are the definative rule(s) here... I was told a long time ago that the *ONLY* situation acceptable to use the same field name in more than one search parameter is with the cl comparison operator. Of course this kind of inportant information never seems to make it into the docs no matter how many years go by. A little bit of effort on SM'a part to document the rules would go a long way here ...Of course, maybe the person who told me that was wrong ... if your example above works, great! Then again, I cannot find your example in the docs, the only thing I see in the docs is two separate descriptions for mr and xr and neither of them have any examples.On the other hand, when using mr and xr they must obviously be used together -- in order to create the range webcatalog uses in its search -- so it only makes sense that webcatalog should not require the group field technique in this case.Perhaps this is one situation where you can actually use two search parameters on the same database field without having to use the group field technique. The only other one I have heard of is when using the cl operator, which I doubt anyone uses anyways.If you actually take a look at the way the cl operator has to be used, you will see that it is inconsistent with the way all other search parameters are used. When the cl operator is used, it absolutely *requires* that the two parameters using the cl prefix appear in the proper order within the search context -- or the results will be very different.Nowhere else in the webdna language does the order of the search parameters matter to webcatalog!================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: dates as search criteria (Kenneth Grome 2000)
  2. Re: dates as search criteria (John Butler 2000)
  3. Re: dates as search criteria (Brian Wachter 2000)
  4. Re: dates as search criteria (Kenneth Grome 2000)
  5. Re: dates as search criteria (Paul Fowler 2000)
  6. dates as search criteria (Brian Wachter 2000)
>I won't forget the 'rule', ...but I AM successfully using this search to find records in a date range and I do believe I got the technique straight from the docs... > >[Search db=some.db >&mrDayOrdereddatarq=[mrDayOrdereddatarq] >&xrDayOrdereddatarq=[xrDayOrdereddatarq] >&max=[max] >&startat=[start] >&DayOrderedtype=date >&TimeOrderedtype=time >&DayOrderedsort=1 >&TimeOrderedsort=2 >&DayOrderedsdir=de >&TimeOrderedsdir=de] > >I don't mean to argue I just would like to know what really are the definative rule(s) here... I was told a long time ago that the *ONLY* situation acceptable to use the same field name in more than one search parameter is with the cl comparison operator. Of course this kind of inportant information never seems to make it into the docs no matter how many years go by. A little bit of effort on SM'a part to document the rules would go a long way here ...Of course, maybe the person who told me that was wrong ... if your example above works, great! Then again, I cannot find your example in the docs, the only thing I see in the docs is two separate descriptions for mr and xr and neither of them have any examples.On the other hand, when using mr and xr they must obviously be used together -- in order to create the range webcatalog uses in its search -- so it only makes sense that webcatalog should not require the group field technique in this case.Perhaps this is one situation where you can actually use two search parameters on the same database field without having to use the group field technique. The only other one I have heard of is when using the cl operator, which I doubt anyone uses anyways.If you actually take a look at the way the cl operator has to be used, you will see that it is inconsistent with the way all other search parameters are used. When the cl operator is used, it absolutely *requires* that the two parameters using the cl prefix appear in the proper order within the search context -- or the results will be very different.Nowhere else in the webdna language does the order of the search parameters matter to webcatalog!================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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 Kenneth Grome

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:

[WebDNA] WebDNA future (2010) WebCatalog [FoundItems] Problem - AGAIN - (1997) show if date < expiry date (2002) sorting and grouping (1998) [WebDNA] Single Sign On using SAML (2015) MS Bug (2003) Can I invoke an ssi plugin from within a webcat page (1997) [WebDNA] v7.x [thisurl] (2010) Attn: Bug in GeneralStore example b15 (1997) autosensing lanague selection (1997) [WebDNA] total (2010) case number with spaces. (2000) ServerQuestion (2000) pictures / referrer etc. (1998) Setting up WebCatalog with Retail Pro data (1996) Calculating multiple shipping... (1997) Re[2]: WebCatalog + Linux + ODBC + Oracle ! ? (2000) Re:2nd WebCatalog2 Feature Request (1996) Re2: Calculating multiple shipping... (1997) Smart caching problems with 2.1b3? (1997)