shipCost formula
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 13985
interpreted = N
texte = (Sorry, I sent this with the wrong subject.)Thank you everyone for all the help. Believe it or not I am actually up and running Webcat (Webmerch is next week's task). I do have one last problem, however. My products don't have a unit ship cost, the cost go like this; 1 video costs $5, 2 cost $6, 3-10 cost $7, and anything over that the shopper has to call in his order. I redid the site, so now everything I have is using the general store templates. So where it specified the formula [unitShipcost] I changed it to say [shipCost] and in the formulas database my formula is: shipCost [lookup db=ShipCosts.db&lookInField=Quantity&value=[Cost]&returnField=shipCost¬F ound=Call for Price]The ShipCosts.db has this:Quantity Cost 1 5 2 6 3 7 4 7 5 7 6 7 7 7 8 7 9 7 10 7My ship costs fields, however, keep reading $0.00. Do you know what is wrong?Thank you so much, as always, Janna****************************** Janna S. Kohen Big Mind Media L. L. C. http://www.bigmindmedia.com/ janna@bigmindmedia.com
Associated Messages, from the most recent to the oldest:
(Sorry, I sent this with the wrong subject.)Thank you everyone for all the help. Believe it or not I am actually up and running Webcat (Webmerch is next week's task). I do have one last problem, however. My products don't have a unit ship cost, the cost go like this; 1 video costs $5, 2 cost $6, 3-10 cost $7, and anything over that the shopper has to call in his order. I redid the site, so now everything I have is using the general store templates. So where it specified the formula [unitShipcost] I changed it to say [shipCost] and in the formulas database my formula is: shipCost [lookup db=ShipCosts.db&lookInField=Quantity&value=[Cost]&returnField=shipCost¬F ound=Call for Price]The ShipCosts.db has this:Quantity Cost 1 5 2 6 3 7 4 7 5 7 6 7 7 7 8 7 9 7 10 7My ship costs fields, however, keep reading $0.00. Do you know what is wrong?Thank you so much, as always, Janna****************************** Janna S. Kohen Big Mind Media L. L. C. http://www.bigmindmedia.com/ janna@bigmindmedia.com
Janna S. Kohen
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:
[authenticate] (1999)
trouble updating records in database (1998)
RE: format problem on NT? (1997)
Requiring that certain fields be completed (1997)
Inventory Control (2000)
SERIAL NUMBER PROBLEM *AGAIN*!!! (1998)
[WebDNA] small bug when searching tables in functions (2011)
Nested tags count question (1997)
price formula (1999)
Append command (2000)
wo search help (1999)
Help! WebCat2 bug (1997)
Summing fields (1997)
credit card authorization question (1997)
Roundup function? (1997)
Large sites (2003)
Upgrade to 3.07 problems (2000)
Contexts and Ampersands (1997)
Re:listfiles-looking for slick solution (1997)
Emailer S-L-O-W-N-E-S-S (2002)