Calculate UnitShipCost in Formulas.db
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24814
interpreted = N
texte = Hi there,I'm trying to calculated the shipping costs based in the weight and distance.I look at the archive and docs and I understand the unitshipcost is calculated when the user add a item to the shoppingcart.tmpl. at that time I don't know in wich city the user want the product to be delivered, in the shoppingcart.tmpl there are an option to select the city and then they pass to the invoice.tmpl. I have in the formulas.db this:unitShipCost [Lookup db=products.db&lookInField=sku&value=[sku]&returnField=unitShipCost]*[lookup db=ShipCosts.db&value=[city]&lookinfield=ShipCity&returnfield=ShipFactor]but when I go to the invoice.tmpl it shows only the value of the unitshipcost I have in products.db an it does't calculated anythig.Could you give me a clue how to do this?Thanks Rodolfo de la Garza-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to
.This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Hi there,I'm trying to calculated the shipping costs based in the weight and distance.I look at the archive and docs and I understand the unitshipcost is calculated when the user add a item to the shoppingcart.tmpl. at that time I don't know in wich city the user want the product to be delivered, in the shoppingcart.tmpl there are an option to select the city and then they pass to the invoice.tmpl. I have in the formulas.db this:unitShipCost [Lookup db=products.db&lookInField=sku&value=[sku]&returnField=unitShipCost]*[lookup db=ShipCosts.db&value=[city]&lookinfield=ShipCity&returnfield=ShipFactor]but when I go to the invoice.tmpl it shows only the value of the unitshipcost I have in products.db an it does't calculated anythig.Could you give me a clue how to do this?Thanks Rodolfo de la Garza-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Rodolfo de la Garza
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:
Calculating a total (2000)
Fedora Core 2 (2005)
template cache problem (1998)
WebCatalog2 Feature Feedback (1996)
Format of Required fields error message (1997)
Add to Cart & List of Products (1997)
Bug Report, maybe (1997)
Email within tmpl ? (1997)
Fun with Dates - revisited (1997)
WebCat2b12 - nesting [tags] (1997)
possible, WebCat2.0 and checkboxes-restated (1997)
adding up in a db (1997)
Help! WebCat2 bug (1997)
Fun with Dates - finally resolved but.... (1997)
Extended [ConvertChars] (1997)
Location of Webcat site in folder hierarchy (1997)
Search Command, multiple dbs, etc. --further elucidation needed (2000)
Newbie HW/SW Setup Question (2000)
webcat plugin issue (2001)
Displays by Categories (2000)