Re: time sort question

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62720
interpreted = N
texte = ding-ding-ding! Thanks On Aug 3, 2005, at 8:53 AM, Donovan Brooke wrote: > Patrick McCormick wrote: > > >> I'm searching a database of events (can you smell the non-profit- >> ness?) >> > > No? :-) > > >> 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] >> > > could the answer be in how the data is put into the database? > > Donovan > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Euca Design Center > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > Euca Design Center > 1871 HWY MM > Fitchburg, WI 53575 > PH:> 1.608.835.2476 > Web:> http://www.egg.bz > http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: time sort question ( Patrick McCormick 2005)
  2. Re: time sort question ( Donovan Brooke 2005)
  3. time sort question ( Patrick McCormick 2005)
ding-ding-ding! Thanks On Aug 3, 2005, at 8:53 AM, Donovan Brooke wrote: > Patrick McCormick wrote: > > >> I'm searching a database of events (can you smell the non-profit- >> ness?) >> > > No? :-) > > >> 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] >> > > could the answer be in how the data is put into the database? > > Donovan > > > -- > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > DONOVAN D. BROOKE Euca Design Center > <-Web Development (specializing in eCommerce), -> > <- Graphic Design, Custom Tags and Labels -> > > ADDRESS:> Donovan Brooke > Euca Design Center > 1871 HWY MM > Fitchburg, WI 53575 > PH:> 1.608.835.2476 > Web:> http://www.egg.bz > http://www.euca.us > =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o > > ------------------------------------------------------------- > 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 digest@talk.smithmicro.com> > Web Archive of this list is at: http://webdna.smithmicro.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://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:

Not really WebCat (1997) [WebDNA] Authorization with .htaccess (2008) is this how [break] works? (1998) Timer Values on [redirect] (1998) addlineitem is not saving a variable. (2004) WebDNA equivalent for $REQUEST_URI (2004) Calculating multiple shipping... (1997) problems with WebCat-Plugin () Line items in table cells (1997) WebDNA and SQL (2003) BUG REPORT: numeric ge, le, gr & ls comparisons don't work ... (1999) Photo Album (2000) Removing [showif] makes a big difference in speed (1997) Separate SSL Server (1997) Quickie question on the email templates (1997) RE: ANother SHOWIF problem (1997) can WC render sites out? (1997) converting characters in form (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) WebCat2b13 Command Reference Doc error (1997)