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 forthe real price. Since that price formula is changing all your pricesto 0.00, you can fix your problem simply by:1-deleting the 'price' record from the formulas.db (don't just deletethe 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 tochange a whole lot of individual price records in your database. Agood price formula can raise or lower prices dynamically ... :)Sincerely, Ken GromeWebDNA Solutionshttp://www.smithmicro.com/webdnasolutions/...
Associated Messages, from the most recent to the oldest:
>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 forthe real price. Since that price formula is changing all your pricesto 0.00, you can fix your problem simply by:1-deleting the 'price' record from the
formulas.db (don't just deletethe 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 tochange a whole lot of individual price records in your database. Agood price formula can raise or lower prices dynamically ... :)Sincerely, Ken GromeWebDNA Solutionshttp://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)