Re: Formatting time output
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30683
interpreted = N
texte = Excellent suggestion!I hadn't thought of using [getchars] and starting at the end...D'oh!--Will StarckProduct and Technical SupportNovaDerm.comhttp://www.novaderm.comtechs@novaderm.comToll free support line: 800-378-1740---------->From: Jason Sofonia
>To: (WebCatalog Talk)>Subject: Re: Formatting time output>Date: Thu, Apr 20, 2000, 12:08>> Will,>> This might not be the *exact* way to solve this problem, but it does work> just the same :)>> I could not get the format context to intrepret an actual time instead of> the string of numbers that represent time.>> Example:> [Format Seconds_To_Time %H:%M]13:49[/Format] ---> 00:00> [Format Seconds_To_Time %H:%M]49768[/Format] ---> 13:49>> So try using this instead...> [getchars start=4&from=end][modtime][/getchars]>> Example:> [text]modtime=[time %H:%M:%S][/text]> [modtime]
> [getchars start=4&from=end][modtime][/getchars]>>> Be sure to keep the moddatetype=date and modtimetype=time in your> searchstring so your results are sorted accurately.>> Hope that helps...>>> Jason Sofonia>> Digital Frontier | jason@digitalfrontier.com>>>>>>>>>>> That sure looks like it'd work, but all it displays is>> 00:00>> ...?> --> Will Starck> Product and Technical Support> NovaDerm.com> http://www.novaderm.com> techs@novaderm.com> Toll free support line: 800-378-1740>> ---------->>From: Jason Sofonia >>To: (WebCatalog Talk)>>Subject: Re: Formatting time output>>Date: Thu, Apr 20, 2000, 9:39>>>>> Will,>>>> try this in your search context...>>>> &moddatetype=date&modtimetype=time>>>>>>>> Jason Sofonia>>>> Digital Frontier | jason@digitalfrontier.com>>>>>>>>>>>> on 04.20.00 10:27 am, Will Starck at daprez@tigernet.net wrote:>>>>> I have times written to a db in the format H:M:S (including colons)>>>>>> I'd like to truncate the output at minutes H:M for display but>>> [format seconds_to_time %H:%M] does not work, presumably because webcat>>> views the data as a text string, right?>>>>>> Any tips for getting this to work??>>>>>> The search looks like:>>>>>> [search>>> db=orders.db&group1field=moddate&group2field=moddate&gegroup1datarq=[startda>>> te]&legroup2datarq=[enddate]&demoddatesort=1&demodtimesort=2]>>> [founditems]>>>>>> ...>>>>>> [modtime]>>>>>>>>> [/founditems]>>>>>> [/search]>>>>>> Thanx>>> -->>> Will Starck>>> Product and Technical Support>>> NovaDerm.com>>> http://www.novaderm.com>>> techs@novaderm.com>>> Toll free support line: 800-378-1740>>>>>> ---------->>> -------------------------------------------------------------> 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 -------------------------------------------------------------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:
Excellent suggestion!I hadn't thought of using [getchars] and starting at the end...D'oh!--Will StarckProduct and Technical SupportNovaDerm.comhttp://www.novaderm.comtechs@novaderm.comToll free support line: 800-378-1740---------->From: Jason Sofonia >To: (WebCatalog Talk)>Subject: Re: Formatting time output>Date: Thu, Apr 20, 2000, 12:08>> Will,>> This might not be the *exact* way to solve this problem, but it does work> just the same :)>> I could not get the format context to intrepret an actual time instead of> the string of numbers that represent time.>> Example:> [Format Seconds_To_Time %H:%M]13:49[/Format] ---> 00:00> [Format Seconds_To_Time %H:%M]49768[/Format] ---> 13:49>> So try using this instead...> [getchars start=4&from=end][modtime][/getchars]>> Example:> [text]modtime=[time %H:%M:%S][/text]> [modtime]
> [getchars start=4&from=end][modtime][/getchars]>>> Be sure to keep the moddatetype=date and modtimetype=time in your> searchstring so your results are sorted accurately.>> Hope that helps...>>> Jason Sofonia>> Digital Frontier | jason@digitalfrontier.com>>>>>>>>>>> That sure looks like it'd work, but all it displays is>> 00:00>> ...?> --> Will Starck> Product and Technical Support> NovaDerm.com> http://www.novaderm.com> techs@novaderm.com> Toll free support line: 800-378-1740>> ---------->>From: Jason Sofonia >>To: (WebCatalog Talk)>>Subject: Re: Formatting time output>>Date: Thu, Apr 20, 2000, 9:39>>>>> Will,>>>> try this in your search context...>>>> &moddatetype=date&modtimetype=time>>>>>>>> Jason Sofonia>>>> Digital Frontier | jason@digitalfrontier.com>>>>>>>>>>>> on 04.20.00 10:27 am, Will Starck at daprez@tigernet.net wrote:>>>>> I have times written to a db in the format H:M:S (including colons)>>>>>> I'd like to truncate the output at minutes H:M for display but>>> [format seconds_to_time %H:%M] does not work, presumably because webcat>>> views the data as a text string, right?>>>>>> Any tips for getting this to work??>>>>>> The search looks like:>>>>>> [search>>> db=orders.db&group1field=moddate&group2field=moddate&gegroup1datarq=[startda>>> te]&legroup2datarq=[enddate]&demoddatesort=1&demodtimesort=2]>>> [founditems]>>>>>> ...>>>>>> [modtime]>>>>>>>>> [/founditems]>>>>>> [/search]>>>>>> Thanx>>> -->>> Will Starck>>> Product and Technical Support>>> NovaDerm.com>>> http://www.novaderm.com>>> techs@novaderm.com>>> Toll free support line: 800-378-1740>>>>>> ---------->>> -------------------------------------------------------------> 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 -------------------------------------------------------------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
Will Starck
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:
Almost a there but..bye bye NetCloak (1997)
Math Help (2000)
Bug? (1997)
Replace context problem ... and answers (1997)
Sorting error (1997)
RE: pricing continued (1998)
[format xs] freeze (1997)
[isfile] ? (1997)
MacAuthorize order data fields WAS:How To question... (1997)
Robert Minor duplicate mail (1997)
Not reading code (1997)
WebCat2.0 [format thousands .0f] no go (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Setting up shop (1997)
emailer (1997)
Notepad problems (1998)
HTML encoding in URLs (1997)
UPPERCASE (1997)
Searching for (field1 OR field2) AND field3 (2000)
RE: automatic reload of frameset (1997)