Re: Formatting time output
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30681
interpreted = N
texte = 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:49So 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 SofoniaDigital Frontier | jason@digitalfrontier.com That sure looks like it'd work, but all it displays is00: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
Associated Messages, from the most recent to the oldest:
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:49So 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 SofoniaDigital Frontier | jason@digitalfrontier.com That sure looks like it'd work, but all it displays is00: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
Jason Sofonia
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:
Repeating Fields (1997)
sort problems....bug or brain fart? (1997)
Add all products to cart at once? (1997)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
Close Databases Crash? (1998)
[WebDNA] WebDNA future (2010)
Search context not finding recent entries (1998)
More news on 5.0 (2003)
webcat 2.1 new cart fields - please explain more (1998)
WebCat2: Items xx to xx shown, etc. (1997)
RE: [WebDNA] German e-shop company proclaims "In Memory Computing" (2010)
[OT] Google Info (2004)
reservation program (2000)
Removing [showif] makes a big difference in speed (1997)
FAX orders (1996)
Summ=T Problem (1997)
Need relative path explanation (1997)
[WebDNA] Triggers failing in sandbox (2008)
4.0.2b5 not finding databases under load (2000)
MacAuthorize and WebMerchant (1997)