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