sort by day of week...
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 49980
interpreted = N
texte = Given a database or regularly scheduled events that are stored as the day of the week they happen and the name of the happening itself. like this:DAY\tEVENT 0\tsomething for Sunday 1\tsomething for Monday 2\tTuesday event 5\tskip to Friday 0\tanother Sunday one 3\Wednesday scheduleAnd given that we know what day today is [date format=%w]I can figure out how to search the database so that today's items are sorted at the top like this:[search db=events.db&geDAYdatarq=[date format=%w]&asDAYsort=1&DAYtype=num]And then I'd have to go through some machinations to get the rest of the days in a second search. What I'd want on Saturday isSaturday Sunday Monday Tuesday ... FridayBut if today is Wednesday, I'd want:Wednesday Thursday Friday ... Monday TuesdayAnyone have a cool trick to do this in one search?~joe -- ____________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access WebCat and MGI database programming ____________________________________________________________------------------------------------------------------------- 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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Given a database or regularly scheduled events that are stored as the day of the week they happen and the name of the happening itself. like this:DAY\tEVENT 0\tsomething for Sunday 1\tsomething for Monday 2\tTuesday event 5\tskip to Friday 0\tanother Sunday one 3\Wednesday scheduleAnd given that we know what day today is [date format=%w]I can figure out how to search the database so that today's items are sorted at the top like this:[search db=events.db&geDAYdatarq=[date format=%w]&asDAYsort=1&DAYtype=num]And then I'd have to go through some machinations to get the rest of the days in a second search. What I'd want on Saturday isSaturday Sunday Monday Tuesday ... FridayBut if today is Wednesday, I'd want:Wednesday Thursday Friday ... Monday TuesdayAnyone have a cool trick to do this in one search?~joe -- ____________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access WebCat and MGI database programming ____________________________________________________________------------------------------------------------------------- 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://webdna.smithmicro.com/
Joe 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:
Sendmail Woes (2002)
New Webcatalog for Mac (1997)
WebCat2b13 Command Reference Doc error (1997)
# of real domains on 1 web server (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
[WebDNA] DigitalOcean Snapshots (2019)
Dubble Sku's in a Database (1999)
WebCat2_Mac RETURNs in .db (1997)
format_to_days on NT (1997)
Error Lob.db records error message not name (1997)
emailer on Windows Beta 18 (1997)
WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997)
Return records from another (1997)
off topic fetch vs PCS photomaster (1997)
WebCatalog for Postcards ? (1997)
Make sure I understand this??? (1997)
Emailer connect failure definitions (2003)
Using Plug-In while running 1.6.1 (1997)
find with exceptions (1997)
WebCat2b12plugin - [search] is broken ... not! (1997)