Re: dates as search criteria

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28627
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...-JohnKenneth Grome wrote:> >OK, I've got a database record where the parameter postingDate is > >02/25/2000 and I'm trying to do a monthly report whereby I select FEB and > >have this record captured. > > > >The following code successfully returns a result: > >[search db=postings.db&nepostingNodatarq=0&eqpostingDatedatarq=02/25/2000] > > > >But the following code return nothing: > >[search > >db=postings.db&nepostingNodatarq=0&gepostingDatedatarq=02/01/2000&postingDa > >tetype=date&lepostingDatedatarq=02/31/2000&postingDatetype=date] > > You *CANNOT* search on one database field with more than one search parameter! > > I think I have mentioned this 3 or 4 times during the past week or two. I know it's an easy rule to forget, but you simply must remember it. Use the group field technique and it will work fine, or use a rn search andenter the smallest value *first* ... :) > > ================================ > 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 ------------------------------------------------------------- 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...-JohnKenneth Grome wrote:> >OK, I've got a database record where the parameter postingDate is > >02/25/2000 and I'm trying to do a monthly report whereby I select FEB and > >have this record captured. > > > >The following code successfully returns a result: > >[search db=postings.db&nepostingNodatarq=0&eqpostingDatedatarq=02/25/2000] > > > >But the following code return nothing: > >[search > >db=postings.db&nepostingNodatarq=0&gepostingDatedatarq=02/01/2000&postingDa > >tetype=date&lepostingDatedatarq=02/31/2000&postingDatetype=date] > > You *CANNOT* search on one database field with more than one search parameter! > > I think I have mentioned this 3 or 4 times during the past week or two. I know it's an easy rule to forget, but you simply must remember it. Use the group field technique and it will work fine, or use a rn search andenter the smallest value *first* ... :) > > ================================ > 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 ------------------------------------------------------------- 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 John Butler

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:

[include] affect on filepaths for links? (1997) Smith Micro - no competition (2000) More ways to search the docs (1998) Calendar (1997) mime types (2003) [writefile] (1997) Text data with spaces in them... (1997) Processing stops (2006) Include vs. lookup? (1998) stopping/restarting service on NT? (1998) calculating shipping costs by a sum of weights (1999) Repeating Fields (1997) Moment of Thanks (1997) Web DNA... (2007) RE: [WebDNA] ubuntu can't append db (2019) Browser Back button (2003) RE: ANother SHOWIF problem (1997) Aaron Kant do contextses (2000) Showing Results Alphabetically in Columns (top to bottom) (2002) Credit card processing - UK (1997)