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 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, 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 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, 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:
[WebDNA] Need to get off! (2008)
Three new problems, maybe a fourth (1997)
WebTen Type 2 Crash on start (2000)
[WebDNA] OT: what is the "right" platform ? (2009)
Web Commerce thoughts and needs.. (1996)
WEBCAT HIERARCHY (1999)
Digest for 4/18/97 (1997)
bcc and sendmail (2001)
Quickie question on the email templates (1997)
PIXO Support (1997)
exclusive db lock with webcat-3 ? (2000)
Free WebDNA snippets (Extending WebCatalog) (1997)
Bug? (1997)
WebCat2b12 - nesting [tags] (1997)
Emailer & WebStar Mail and 551 Error (2000)
Banners and sort of random display (1997)
Using Cookie for client specific info? (1997)
Field name-subcategory (1997)
Error Template (1999)
Redirect frame targets (1998)