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:

ThisAutoNumber (2003) RE: Webcatalog and CyberSTUD (1998) Sorting error (1997) RE: [WebDNA] Styling search results [using css] (2009) [WebDNA] Help with ReplaceFoundItems (2009) WebCatalog for guestbook ? (1997) WCf2 and nested tags (1997) Cookies and webcat (1997) Bay Area Residents / Bay To Breakers (1998) Price Not Appearing (2000) displaying New products (Yikes! it's Fixed!) (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) WC 2.0 frames feature (1997) How To question on setting up downloads (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCat2b13 Command Reference Doc error (1997) group searching problem (2002) [WebDNA] Sorry WebDNA server not running. (2017) WebCat2 - Getting to the browser's username/password data (1997) greater than or equal to (1997)