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:
[WriteFile] problems (1997)
Custom error files (1998)
Cancel Subscription (1996)
$flushcache causes crash (2000)
Using webcat to roll apache logs (2002)
[WebDNA] To Commitdatabase or Not to Commitdatabase (2012)
Re1000001: Setting up shop (1997)
WebDNA 5.0 Enterprise Edition (2003)
search multiple fields from one input (1998)
OT: Java1.3.0 (2002)
WebCat2: Items xx to xx shown, etc. (1997)
OT: RAID Options (2004)
Bulletin Board (1998)
UPDATE PROBLEM (1997)
WebMerchant 3.0? (1998)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Ampersand (1997)
Is there a max number of fields? (1998)
Protect vs Authenicate (1997)
form data submission gets truncated (1997)