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]*[looku p 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:

    
  1. Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
  2. Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  3. Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
  4. Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
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]*[looku p 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)