Re: &FieldNametype=time unnecessary?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 26386
interpreted = N
texte = >I see in the docs how to sort by date using the >FieldNametype=date > >but what about sorting by time? I don't see any reference to a FieldNametype=time... so can >I assume that the default behaviour will always do the right thing when I sort by a field >with time values?Assuming you store your time values in the default HH:MM:SS format, then yes, they will always sort properly as text -- which means you do not need the FieldNametype=time parameter. The only time you might need to use that parameter is if you change the way you store times in your db to a different format.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Associated Messages, from the most recent to the oldest:

    
>I see in the docs how to sort by date using the >FieldNametype=date > >but what about sorting by time? I don't see any reference to a FieldNametype=time... so can >I assume that the default behaviour will always do the right thing when I sort by a field >with time values?Assuming you store your time values in the default HH:MM:SS format, then yes, they will always sort properly as text -- which means you do not need the FieldNametype=time parameter. The only time you might need to use that parameter is if you change the way you store times in your db to a different format.================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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 Kenneth Grome

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:

WebCat2b12plugin - [search] is broken ... not! (1997) Webcat no longer supported? (2006) Problem (1997) Execute Applescript (1997) Problem 2: Prefs file... (1997) Re:Signal Raised (1997) Trouble with Netscape (1998) Sendmail Woes (2002) [WebDNA] Advanced search 'rq' problem (2013) Cancel Subscription (1996) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Forcing a NEWCART (1997) [WebDNA] Why doesn't this returnraw redirect to the new page? (2009) New Guestbook Source (1997) Drop Down Menu from comma delimited values. (2002) Date search - yes or no (1997) Here we go again... (2006) WebCatalog Upgrade Pricing? (1997) textA (1998) OT : Best book for OSX (2002)