Re: ANother SHOWIF problem
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13454
interpreted = N
texte = >In my database, I have divided the on sale date of an item into month >(1-12), day (1-31), and year (01-99) fields (for a number of reasons).What's the name of your on sale date field? You named it date, didn't you? That's the problem ... :)>For some reason, the following code (which is inside a [SEARCH] context) >*always* displays the on sale date. > >[SHOWIF [MATH][DATE][/MATH]<[MATH]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale >[MTH]/[DAY]/[YR][/SHOWIF]You didn't mention it, but this WebDNA is also located inside a [founditems] context, isn't it? Here's what you're running into ...When WebCat sees a [date] tag inside a [founditems] context, it looks for a field in the database named date, and it uses that value instead of the server date.That's why it is never a good idea to use date as a field name, because eventually you will want to do something exactly like what you're trying to do, and then you will run into the problem you're seeing now - WebCat is using the 'date' value stored in your database instead of the server's date.All you have to do is change the name of your 'date' field to something else - like SaleDate for example. Then when WebCat sees [date] in your WebDNA, it will NOT be able to find a field in your database named date, so it will use the date value from your server instead ... :)Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html
Associated Messages, from the most recent to the oldest:
>In my database, I have divided the on sale date of an item into month >(1-12), day (1-31), and year (01-99) fields (for a number of reasons).What's the name of your on sale date field? You named it date, didn't you? That's the problem ... :)>For some reason, the following code (which is inside a
[search] context) >*always* displays the on sale date. > >[SHOWIF
[math][date][/MATH]<
[math]{[MTH]/[DAY]/[YR]}[/MATH]]
On sale >[MTH]/[DAY]/[YR][/SHOWIF]You didn't mention it, but this WebDNA is also located inside a
[founditems] context, isn't it? Here's what you're running into ...When WebCat sees a
[date] tag inside a
[founditems] context, it looks for a field in the database named date, and it uses that value instead of the server date.That's why it is never a good idea to use date as a field name, because eventually you will want to do something exactly like what you're trying to do, and then you will run into the problem you're seeing now - WebCat is using the 'date' value stored in your database instead of the server's date.All you have to do is change the name of your 'date' field to something else - like SaleDate for example. Then when WebCat sees
[date] in your WebDNA, it will NOT be able to find a field in your database named date, so it will use the date value from your server instead ... :)Sincerely, Ken Grome WebDNA Solutions http://www.hui.net/dna/webdna.html
Kenneth Grome
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:
no global [username] or [password] displayed ... (1997)
Error handling for accountNum (1997)
upgrading (1997)
searchable list archive (1997)
Banners (1997)
RE: combining strings (1997)
I'm having trouble using [url][interpret][math] together in lookup (1997)
Searching multiple fields (1997)
Limit to Field Length in DB (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
template includes encrypted template (1999)
WebCat2: multiple currency support (1997)
WebCatalog Plug-in for Webstar. (1997)
Navigator 4.01 (1997)
Variable Prices (1998)
Extended [ConvertChars] (1997)
RE: [WebDNA] Grep (2009)
CASTEGORIES IN DIFFERENT FRAMES (1997)
In Digest Dijon (2000)
[WebDNA] DNA suffix (2008)