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:

    
  1. 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:

[WebDNA] making all fields on a form mandatory (2013) Quit revisited (1997) Purchase Plugin Missing (1996) Cart date/time (2006) sorry (1997) WebCAT has the devil in it! (2003) WebMerchant 1.6 and https (1997) [WebDNA] MD5 Hash issue (2009) Exclamation point (1997) [Capitalize] (1998) Undocumented changes create problems in webcat 4 ... (2000) weird happenings (1997) automating txt downloads for conversion to webcat db (2006) Where is f2? (1997) [OT] Display Glitch (2004) [isfile] ? (1997) Server IP address? (1998) [ShowCart] and GET vs. POST (1997) Problem (1997) problems with 2 tags (1997)