Re: Problems with Price field

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 15352
interpreted = N
texte = >I am at a loss... I've tried everything I can think of to do. > >I have a Catalog site... I used the Tearoom example as my original model. >My results.tmpl shows everything fine. SKU, name, desc, price. When I add >an item to the shopping cart, the item is also added fine. I can see SKU, >name, desc, etc. Unfortunately, the price is 0 on all items. > >I have tried bringing in another field instead of price, and it works fine. > >I have tried duplicating the price field and calling it 'pce'... it works >fine. > >For some reason any field called price will not come in. This is obviously >a major problem since I can't do subtotals, etc. > >I've been stuck on this one for sometime now. I should have sent a request >to the group sooner. Any ideas? Hi Eddie,There's probably a formula in your formulas.db called price, right? That formula tells WebCat to substitute the FORMULA-based price for the real price. Since that price formula is changing all your prices to 0.00, you can fix your problem simply by:1-deleting the 'price' record from the formulas.db (don't just delete the Formula value, you should remove the entire database record), or ...2- changing the price formula so it works properly.The reason for using a price formula, besides insuring price security (which is important) is to let you adjust prices without having to change a whole lot of individual price records in your database. A good price formula can raise or lower prices dynamically ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... Associated Messages, from the most recent to the oldest:

    
  1. Cart creation techniques (was Re: Problems with Price field) (Kenneth Grome 1997)
  2. Re: Problems with Price field (Eddie Lutz 1997)
  3. Re: Problems with Price field (Grant Hulbert 1997)
  4. Re: Problems with Price field (Kenneth Grome 1997)
  5. Problems with Price field (Eddie Lutz 1997)
>I am at a loss... I've tried everything I can think of to do. > >I have a Catalog site... I used the Tearoom example as my original model. >My results.tmpl shows everything fine. SKU, name, desc, price. When I add >an item to the shopping cart, the item is also added fine. I can see SKU, >name, desc, etc. Unfortunately, the price is 0 on all items. > >I have tried bringing in another field instead of price, and it works fine. > >I have tried duplicating the price field and calling it 'pce'... it works >fine. > >For some reason any field called price will not come in. This is obviously >a major problem since I can't do subtotals, etc. > >I've been stuck on this one for sometime now. I should have sent a request >to the group sooner. Any ideas? Hi Eddie,There's probably a formula in your formulas.db called price, right? That formula tells WebCat to substitute the FORMULA-based price for the real price. Since that price formula is changing all your prices to 0.00, you can fix your problem simply by:1-deleting the 'price' record from the formulas.db (don't just delete the Formula value, you should remove the entire database record), or ...2- changing the price formula so it works properly.The reason for using a price formula, besides insuring price security (which is important) is to let you adjust prices without having to change a whole lot of individual price records in your database. A good price formula can raise or lower prices dynamically ... :)Sincerely, Ken Grome WebDNA Solutions http://www.smithmicro.com/webdnasolutions/... 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:

Help name our technology! (1997) WebCatalog can't find database (1997) Loss in Form (1998) Likelihood of a duplicate (2005) email [title] (1997) [WebDNA] Intranet site request (2010) [WebDNA] after latest OSX upgrade, WebDNA not running? (2011) Using Plug-In while running 1.6.1 (1997) Out of the woodwork (2007) [OT] PHP?MySQL Help Needed (2003) Removing and Reinstalling Typhoon (2000) Ship Cost Not working (2000) test (2000) Deleting associated records from 2 different databases (2001) Apache 2.2 (2007) Re:no [search] with NT (1997) [OT] KeepItUp for Windows (2003) Nested Loops and SHOWIFs (1997) Return records from another (1997) Emailer (1997)