summarizing date search by month...
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 33260
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
John
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:
Show if file exists (2004)
template cache problem (1998)
Exists? (1997)
Search Question (2000)
Support ?? (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Sorting Orders (1997)
IE4.5 bug FYI (1999)
Nesting format tags (1997)
Any limit to [include] (1997)
[ConvertChars] problem (1997)
Cookie setting (2003)
problem: search crashes webstar (1997)
StoreBuilder Q's (2003)
Another question (1997)
sendmail Q (2001)
passing info to thankyou.tpl (1998)
WebCat2b15MacPlugin - [protect] (1997)
[OT] FTP client (2003)
Max Record length (1997)