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:

Thanks and Big News!!! (1997) Need relative path explanation (1997) WSDL Wizard (2003) [OT] Satellite (2005) Multiple catalog databases and showcart (1997) What am I doing wrong? (2000) Help! WebCat2 bug (1997) lookup and two records? (1997) Include a big block of text (1997) Bug (feature) in v6 listfiles shows hidden files ... (2004) [FoundItems] solved - thanks (1997) Running 2 two WebCatalog.acgi's (1996) [WebDNA] [PROTECT] - Log Out (2011) Webcatalog, Webstar and Crasharama (1999) Sorting by date (1997) b12 cannot limit records returned and more. (1997) Read and weep (2003) PCS Frames (1997) Calendar (1997) Caching pages...again (2001)