Re: Shipping still a problem!!
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21855
interpreted = N
texte = Jim,It looks like you just need to remove the shipCost calculation out ofthe formulas.db, and just use unitShipCost like so:unitShipCost [lookupdb=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for eachproduct, is this correct?) Let me know if that helps.JohnJim O'Connor wrote:> > Will someone PLEASE help me out with a straight answer here!> > The situation:> > I have to charge shipping based on this formula - shipVia * total number> of items ordered> > example - Canada UPS $15.00 * 3 copies of software = $45.00> Example data is:> > in the mainevent.db -> SKU Title Price Domestic Canada Intnl> 001 PhotoScripter - Single User 299.00 7 15 25> 002 Scripter 2 199.00 7 15 25> 003 ScriptBase 59.00 7 15 25> > in Formulas.db -> Name Formula> shipCost [lookup> db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]> > in ShipCosts.db -> ShipMethod ShipCost> Domestic 7.00> Canada 15.00> Intnl 25.00> > On the Invoice I cakll for unitShipCost and shippingTotal> > Can someone tell me what's going wrong?> > Thanks,> > Jim
Associated Messages, from the most recent to the oldest:
Jim,It looks like you just need to remove the shipCost calculation out ofthe
formulas.db, and just use unitShipCost like so:unitShipCost [lookupdb=shipcosts.db&LookInField=shipMethod&value=[shipVia]&returnField=ShipCost¬Found=0](Of course, I am assuming that the shipping costs are identical for eachproduct, is this correct?) Let me know if that helps.JohnJim O'Connor wrote:> > Will someone PLEASE help me out with a straight answer here!> > The situation:> > I have to charge shipping based on this formula - shipVia * total number> of items ordered> > example - Canada UPS $15.00 * 3 copies of software = $45.00> Example data is:> > in the mainevent.db -> SKU Title Price Domestic Canada Intnl> 001 PhotoScripter - Single User 299.00 7 15 25> 002 Scripter 2 199.00 7 15 25> 003 ScriptBase 59.00 7 15 25> > in
formulas.db -> Name Formula> shipCost [lookup> db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost]> > unitShipCost [lookup> db=mainevent.db&lookInField=sku&value=[sku]&returnField=[shipVia]]> > in ShipCosts.db -> ShipMethod ShipCost> Domestic 7.00> Canada 15.00> Intnl 25.00> > On the Invoice I cakll for unitShipCost and shippingTotal> > Can someone tell me what's going wrong?> > Thanks,> > Jim
John W
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:
[isfile] ? (1997)
test (2000)
shownext & math (1997)
WCf2 and nested tags (1997)
New Command prefs ... (1997)
ReturnRaw and redirect one last question (1997)
Encrypt/decrypt bug in 3.0.5b12 (1999)
Emailer (1997)
Can someone help? (2000)
Odd request (2003)
Upgrade to 4.0 (2001)
[SearchString] usage (1997)
syntax question, not in online refernce (1997)
My slower response (1997)
failure to encrypt (or maybe decrypt) (1999)
WebCat2 beta 11 - new prefs ... (1997)
server2003 isolation mode (2004)
Running subtotal? (1998)
[WebDNA] New request for websites that currently run WebDNA (2009)
WebCatalog for WebStar V (2001)