Re: summarizing date search by month...
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33263
interpreted = N
texte = Basically I think you will need a nested search. The outside search does a sorted date summary search on your event date and the inner search lists the individual items... something like this:[search... neEVENTDATEdata=0&EVENTDATEtype=date&asEVENTDATEsort=1&EVENTDATEsumm=t ] [founditems] Events for [EVENTDATE}
[search... &eqEVENTDATEdata=[EVENTDATE] [founditems] [EVENTNAME]
[/founditems] [/search] [/founditems][/search] [/joe] At 7:36 PM 6/15/00, John wrote: >ok here is what I am trying to do.. >I have a bunch of events in a db with a date 01/01/2000 (and the >webcat prefs set the same). I can return a search and sort it by >date. > >What I would like to do is have the results sort of like this... > >month > all events in the month sorted >next month > all the events, etc. > >I have two problems... > >1. converting a date to a month (since I have no month field) .. I >thought of using a lookup with a convert_db but seems like I would >need to do a wildcard for day and year.. is this possible? > >2. having the founditems not repeat the month with each returned record... > >any help would be appreciated.... > >john > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/_________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Basically I think you will need a nested search. The outside search does a sorted date summary search on your event date and the inner search lists the individual items... something like this:[search... neEVENTDATEdata=0&EVENTDATEtype=date&asEVENTDATEsort=1&EVENTDATEsumm=t ] [founditems] Events for [EVENTDATE}
[search... &eqEVENTDATEdata=[EVENTDATE] [founditems] [EVENTNAME]
[/founditems] [/search] [/founditems][/search] [/joe] At 7:36 PM 6/15/00, John wrote: >ok here is what I am trying to do.. >I have a bunch of events in a db with a date 01/01/2000 (and the >webcat prefs set the same). I can return a search and sort it by >date. > >What I would like to do is have the results sort of like this... > >month > all events in the month sorted >next month > all the events, etc. > >I have two problems... > >1. converting a date to a month (since I have no month field) .. I >thought of using a lookup with a convert_db but seems like I would >need to do a wildcard for day and year.. is this possible? > >2. having the founditems not repeat the month with each returned record... > >any help would be appreciated.... > >john > >------------------------------------------------------------- >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 > >Web Archive of this list is at: http://search.smithmicro.com/_________________________________________________ Joseph D'Andrea JoeDan@West21.com WEST21.com Internet services for the 21st Century http://www.west21.com/ _________________________________________________ ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/
Joseph D'Andrea
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:
command parameters (1998)
archives down (2001)
re: [addlineitem] working almost (1997)
many-to-one problem (1998)
URL for Discussion Archive (1997)
[UPPERCASE] (1997)
WebCatalog can't find database (1997)
Location of Browser Info.txt file (1997)
WebCat BeOS (2002)
A quickie question (1997)
Nested tags count question (1997)
Thanks Grant (1997)
WebCat NT v. Mac (1997)
(2000)
If Empty ? (1997)
Still can't get this taxrate to work... (1999)
PixelPipe for Windows? (2003)
problems with 2 tags shakur (1997)
Alternative colors? (2000)
Mailing Labels (2005)