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:

Sorting Orders (1997) using showpage and showcart commands (1996) listing certain items in the orderfile (2002) Logging purchases (1997) WebCommerce Security Alert! (1996) [WebDNA] WebDNA vs. php war ;-) (2010) WebCat2: Formulas.db question (1997) HomePage Caution (1997) [platform] tag? (1998) Happy Easter ... and grep string request ... (2004) NT Setup (1998) Help with nested search (1998) [WebDNA] Google Cloud (2014) Press Release hit the NewsWire!!! (1997) Help name our technology! (1997) Paths (1998) FCKeditor (2008) Still Stumped on ShowNext...HELP! (1997) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) Template Security error (1997)