shipCost problems

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 32212
interpreted = N
texte = Hi all,I am sitting over this for quite some time but can't get it to work. This code works on one site but not on the other.Formulas.db:Name Formula shipCost [math show=f]totalWeight=[lineitems][lookup db=data/products.db&lookInField=sku&value=[sku]&returnField=gewicht]*[quanti ty]+[/lineitems]0[/math][search db=data/ShipTable.db&leAmountdata=[totalWeight]&deAmountsort=1&Amounttype=nu m&max=1][founditems][Cost][/founditems][/search]ShipTable.db:Amount Cost 40 20If I only have 40 KG in the ShipTable.db file shouldn't WebCat just bill everything under 40 Kg to 20.00?Sincerely, Nitai-- E-Commerce Solutions for Unix, NT and Mac Eyework - http://eyework.net/EMail: Info@eyework.net Tel: +41 (0)52 / 654 15 55, Fax: +41 (0)52 / 654 15 59 ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. shipCost problems (Nitai @ Eyework 2000)
  2. Re: ShipCost Problems (PCS Technical Support 1998)
  3. ShipCost Problems (Richard Kirsner 1998)
Hi all,I am sitting over this for quite some time but can't get it to work. This code works on one site but not on the other.formulas.db:Name Formula shipCost [math show=f]totalWeight=[lineitems][lookup db=data/products.db&lookInField=sku&value=[sku]&returnField=gewicht]*[quanti ty]+[/lineitems]0[/math][search db=data/ShipTable.db&leAmountdata=[totalWeight]&deAmountsort=1&Amounttype=nu m&max=1][founditems][Cost][/founditems][/search]ShipTable.db:Amount Cost 40 20If I only have 40 KG in the ShipTable.db file shouldn't WebCat just bill everything under 40 Kg to 20.00?Sincerely, Nitai-- E-Commerce Solutions for Unix, NT and Mac Eyework - http://eyework.net/EMail: Info@eyework.net Tel: +41 (0)52 / 654 15 55, Fax: +41 (0)52 / 654 15 59 ------------------------------------------------------------- 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 Web Archive of this list is at: http://search.smithmicro.com/ Nitai @ Eyework

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:

Search Command, multiple dbs, etc. (2000) SpamCop Blues (was Sending emails before it (went[ot] )) (2002) WebCat2 several catalogs? (1997) URL for Discussion Archive (1997) What are SMSI's upgrade policies? (2003) Help! (2000) Calculating multiple shipping... (1997) Running _every_ page through WebCat ? (1997) [WebDNA] PayPal integration code examples? (2011) Same DB Same Time (2004) credit card (1997) WebCat for mass emailings (1997) WebCat2: multiple currency support (1997) MacAuthorize order data fields WAS:How To question... (1997) [Sum] function? (1997) Cart questions (1997) please unsubscribe me! (2000) when is failing to [URL]ize values in a comparison risky? (1999) server side includes & webcatalog (2000) Adding multiple items to Cart at one time, & append context problem (1998)