Re: MATH TIME
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 14876
interpreted = N
texte = >Now it looks like this and still does not work. >What else can be wrong? > >[search db=users1.tab&eqdatedata=[date]] >[founditems] >[showif [time]>[math time]{[time]}-{00:10:00}[/math]] >
*[user] >[/showif] >[/founditems] >[/search]You'll have to try some things to see what's going on here. Break out some of the tags inside there and see what their values are. Simplify the problem and display each of the pieces separately. Something like the following:[date] [time] [math time]{[time]}-{00:10:00}[/math] [showif 12:53:16>12:43:16] correct [/showif] [showif 12:53:16<12:43:16] not correct [/showif]Also, are you trying to use [time] two different ways here? In one case, does it mean the current server time, and in another case, does it mean the value of the [time] field in the database? If so, that's your problem -- WebCatalog can't tell the difference between [time] and [time] (notice how similar they look). It would be a good idea to rename your fieldnames something different.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
>Now it looks like this and still does not work. >What else can be wrong? > >[search db=users1.tab&eqdatedata=
[date]] >
[founditems] >[showif
[time]>[math time]{
[time]}-{00:10:00}[/math]] >
*[user] >[/showif] >[/founditems] >[/search]You'll have to try some things to see what's going on here. Break out some of the tags inside there and see what their values are. Simplify the problem and display each of the pieces separately. Something like the following:
[date] [time] [math time]{
[time]}-{00:10:00}[/math] [showif 12:53:16>12:43:16] correct [/showif] [showif 12:53:16<12:43:16] not correct [/showif]Also, are you trying to use
[time] two different ways here? In one case, does it mean the current server time, and in another case, does it mean the value of the
[time] field in the database? If so, that's your problem -- WebCatalog can't tell the difference between
[time] and
[time] (notice how similar they look). It would be a good idea to rename your fieldnames something different.Grant Hulbert, V.P. Engineering | ==== eCommerce for the Rest of Us ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Grant Hulbert
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] [data] and RETS (2009)
mail sent from webcatalog. accented chars! (1998)
Type 11 errors setting up WebCAt 2 (1997)
Re(6): Small Bug: ErrorLog.txt/[FORMVARIABLES]/[ORDERFILE] (1998)
WC Database Format (1997)
[subTotal] pricefield in another database !? (1998)
WCS Newbie question (1997)
Initiating NewCart (1997)
WebCat2b15MacPlugin - showing [math] (1997)
WebCat2b12--[searchstring] bug (1997)
Problems with [Applescript] (1997)
Next (1997)
what servers are supported for Typhoon? (1997)
attaching a file using [sendmail]? (2002)
need help with [sendmail] and [showif]s (1998)
Nested [SEARCH] and [REPLACE] problem. (1997)
[OT] FTP client (2003)
Removing carriage returns and line feeds (2006)
Plain tex spacing for html? (2003)
Kaaaaahhhhhhhnnnnnnn! (1997)