time sort question
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 62718
interpreted = N
texte = I'm searching a database of events (can you smell the non-profit- ness?) and sorting the results by time of day. The search string specifies that the time field is data type 'time'.The bad news is that 12 noon, 12:30 pm, etc. all get listed after 1 - 11pm. Is this a bug?Here's the search string:[search db=../db/events.db&geEVFDATEdata=[math]{[date]}[/math] &asEVSDATEsort=1&asEVTIMEsort=2&EVTIMEtype=time]-------------------------------------------------------------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:
I'm searching a database of events (can you smell the non-profit- ness?) and sorting the results by time of day. The search string specifies that the time field is data type 'time'.The bad news is that 12 noon, 12:30 pm, etc. all get listed after 1 - 11pm. Is this a bug?Here's the search string:[search db=../db/events.db&geEVFDATEdata=[math]{[date]}[/math] &asEVSDATEsort=1&asEVTIMEsort=2&EVTIMEtype=time]-------------------------------------------------------------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/
Patrick McCormick
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:
Attention all list readers (1997)
[math] are you there? (1999)
Requiring that certain fields be completed (1997)
Error:Too many nested [xxx] contexts (1997)
WebCatalog losing Data (2001)
WCS Newbie question (1997)
nesting limits? (1998)
Is there an alternative to emailer? (1999)
Webmerchant (1999)
WebCat2: Items xx to xx shown, etc. (1997)
[delete] problem (1997)
Customer - again (1998)
docs for WebCatalog2 (1997)
[math] storage of variables (1997)
MailScanner (2004)
webcat nt (1997)
[WriteFile] problems (1997)
shoppingcart reload qty (1997)
Progress !! WAS: Trouble with formula.db (1997)
color and size options (1997)