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] how to clear the [username] and [password] values the browser has stored? (2008)
Sort Order on a page search (1997)
Search returns all, not 20 (1997)
Mixing and/or in searches (1998)
RE: Automatic thumbnail images (1998)
MacAuthorize and WebMerchant (1997)
[SHOWIF] (1997)
Forms Search Questions (1997)
Plugin or CGI or both (1997)
Export database record - append to other database (2005)
Resume Catalog ? (1997)
Setting a null value for reply to address using sendmail... (2001)
[WebDNA] Probably a stupid question but... (2009)
The Guru Speaks-Is That Really the Only Manuel? (1998)
Displaying photo attached to first record (1997)
HELP WITH DATES (1997)
2.0 Info (1997)
Date Help! (2003)
Will swap web catalog hosting for some light development (2001)
pop up menu's (1998)