Re: dates as search criteria

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 28590
interpreted = N
texte = >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 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)
>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 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:

Searching multiple Databases (1997) [WebDNA] [BULK] WebDNA AJAX example wanted! (2010) WebCat2b15MacPlugin - [protect] (1997) f2 download problems (1997) wo search help (1999) japanese characters (1997) WebDNA 6.0 NOT Configured fot accept domain (2006) linetiems in thankyou.tpl (1997) problems with 2 tags (1997) Purchase Plugin Missing (1996) WebCat2b15MacPlugin - [protect] (1997) Searching a field and returning the highest value (1997) WebDNA reviews? (2002) Wanted: More Math Functions (or, Can You Solve This?) (1997) Limitations on fields? Server is crashing (1997) Webcat2, WebCommerce, Mod 10 etc. (1997) Design Help Needed (1998) [OT] Accepting Credit Cards Online (1999) Mass download. (2003) PCS Frames (1997)