Re[2]: [foundItems] context question --returns some fields b
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30120
interpreted = N
texte = [format .2f][price][/format] only formats numeric values. The string $10.00 is interpreted as the number 0. You cannot have formatting characters like $ in a field you want to treat as a number.John Peacock ____________________Reply Separator____________________ Subject: Re: [foundItems] context question --returns some fields but Author:
(WebCatalog Talk) Date: 4/6/2000 9:53 AMI think I may have answered my own question. I flushed the cache and prices started showing up. (I hadn't flushed cache since I modified field names.) Only prices in my db without $ in front of them show up. What syntax in the code below causes prices with $ to not show up.Thanks everybody. Hope it's as sunny and warm wherever you are as it is here in WV!Anup setty wrote:> I think it is because of your [format] tag, > > [format .2f][price][/format] > > it is giving you only the 2 decimal places, or may be > the PRICE field has no value. Try changing the format to 8.2f or what ever > number you want. > > anup > > ----- Original Message ----- > From: Robert McPeak > To: WebCatalog Talk > Sent: Thursday, April 06, 2000 9:33 AM > Subject: [foundItems] context question --returns some fields but not > others-- > > > Could someone shed some light on why the following code returns data > > from the [title] field, the [SKU] field, but will only return 0.00 in > > the [price] field? > > > > This code came from the TeaRoom. I've just added my particulars. > > > > Thank you thank you! > > > > [foundItems] > > > > | [SKU] | > > [title] | > > [format .2f][price][/format] | > > > > HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=fitproducts.db&sku=[url][s > ku][/url]>Add > > to Cart | > > > HREF=Detail.tpl?cart=[cart]&sku=[url][sku][/url]>Detail | > >
> > [/foundItems] ------------------------------------------------------------- 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:
| |
- Re[2]: [foundItems] context question --returns some fields b (jpeacock@univpress.com 2000)
|
[format .2f][price][/format] only formats numeric values. The string $10.00 is interpreted as the number 0. You cannot have formatting characters like $ in a field you want to treat as a number.John Peacock ____________________Reply Separator____________________ Subject: Re: [founditems] context question --returns some fields but Author: (WebCatalog Talk) Date: 4/6/2000 9:53 AMI think I may have answered my own question. I flushed the cache and prices started showing up. (I hadn't flushed cache since I modified field names.) Only prices in my db without $ in front of them show up. What syntax in the code below causes prices with $ to not show up.Thanks everybody. Hope it's as sunny and warm wherever you are as it is here in WV!Anup setty wrote:> I think it is because of your [format] tag, > > [format .2f][price][/format] > > it is giving you only the 2 decimal places, or may be > the PRICE field has no value. Try changing the format to 8.2f or what ever > number you want. > > anup > > ----- Original Message ----- > From: Robert McPeak > To: WebCatalog Talk > Sent: Thursday, April 06, 2000 9:33 AM > Subject: [founditems] context question --returns some fields but not > others-- > > > Could someone shed some light on why the following code returns data > > from the [title] field, the [SKU] field, but will only return 0.00 in > > the [price] field? > > > > This code came from the TeaRoom. I've just added my particulars. > > > > Thank you thank you! > > > > [founditems] > > > > | [SKU] | > > [title] | > > [format .2f][price][/format] | > > > > HREF=ShoppingCart.tpl?command=add&cart=[cart]&db=fitproducts.db&sku=[url][s > ku][/url]>Add > > to Cart | > > > HREF=Detail.tpl?cart=[cart]&sku=[url][sku][/url]>Detail | > >
> > [/foundItems] ------------------------------------------------------------- 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
jpeacock@univpress.com
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:
Separate SSL Server (1997)
_ in front of field name (1998)
Templates for Customer Database? (1997)
when is failing to [URL]ize values in a comparison risky? (1999)
Req: Array Tags Explained, simple and clear (2004)
[WebDNA] Resolve IP to Domain (2018)
RE: Which [index]? (1997)
Need help with search title (1998)
Another question (1997)
WC 2.0 frames feature (1997)
Does anyone have a solution ? (1998)
Re:Emailer and encryption (1997)
Re:Searching for ALL / empty form field (1997)
searching problem (1998)
Frames and WebCat (1997)
PCS Frames (1997)
Searching multiple fields (1997)
[isfile] ? (1997)
Date sorting (1997)
emailer w/F2 (1997)