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\tEVENT0\tsomething for Sunday1\tsomething for Monday2\tTuesday event5\tskip to Friday0\tanother Sunday one3\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 isSaturdaySundayMondayTuesday...FridayBut if today is Wednesday, I'd want:WednesdayThursdayFriday...MondayTuesdayAnyone 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:

Re: sort by day of week... (Brian Fries 2003) sort by day of week... (Joe D'Andrea 2003)

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\tEVENT0\tsomething for Sunday1\tsomething for Monday2\tTuesday event5\tskip to Friday0\tanother Sunday one3\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 isSaturdaySundayMondayTuesday...FridayBut if today is Wednesday, I'd want:WednesdayThursdayFriday...MondayTuesdayAnyone 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:

Question (1998) TeaRoom Order fields email account remain empty even thoughthewy are filled. (1997) WCS Newbie question (1997) eCommerce software pricing (1998) Help! WebCat2 bug (1997) creating an index based on first letter of word in specificfield in database (2002) Sort Issue? (2000) price on detail, but not shoppingcart (1997) Shipping rate x Quantity solution needed (2000) Y2k compliance (1998) Satistics (1999) WebCatalog for guestbook ? (1997) writing db to disk (1997) If then confusion (2004) Add to Cart & List of Products (1997) [CART] (1997) Error & Problem (1997) Upgrading old WebCat Database Files (1997) Searchable list archive (1997) Multiple fields on 1 input (1997)