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