Re: time sort question

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62719
interpreted = N
texte = 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 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)
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 Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

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 interpreting Q (2001) AND/OR searches in WebCat 3.07 (2003) Incorrect Value Display (2000) lookup and two records? (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) customizing the color of user's pages (1997) Replacing a Word (1999) No luck with taxes (1997) WebDNA Solutions ... sorry! (1997) Requiring that certain fields be completed (1997) More on the email templates (1997) Confused about QTY and QTY* price updating (1998) Formvariables name matching (2005) Donovan (2003) instant cookies? (1999) WebCatalog NT beta 18 problem (1997) [date] +1 (1999) Searching multiple fields from one form field (1997) return missing item (was:WebCat Sales) (1997) DataBaseHelper Flawed (1997)