ShipCost formula (for weight *and* quantities)?

This WebDNA talk-list message is from

1998

It keeps the original formatting. numero = 22038
interpreted = N
texte = Hi all,Just realized my shipcost formula is not properly accounting for line itemsthat have a quantity of more than one! (ooops!)I've tried playing with the formula live on the server, but am missingsomething. Here's my current formula:[lookup db=ShipCosts.db&lookInField=weight&value=[math][lineItems]([lookupdb=pricing.db&lookInField=sku&value=[sku]&returnField=weight]*[quantity])+[/lineItems]0[/math]&returnField=[shipVia]]I'm trying to multiply the weight of an item by the quantity selected forthat item. I'm moving to my development server to continue to play with it,but wonder if anyone can quickly spot the flaw in my formula?Thanks,Dale Stokdykdstokydk@dvs.mv.com Associated Messages, from the most recent to the oldest:

Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998) ShipCost formula (for weight *and* quantities)? (Dale Stokdyk 1998)

Hi all,Just realized my shipcost formula is not properly accounting for line itemsthat have a quantity of more than one! (ooops!)I've tried playing with the formula live on the server, but am missingsomething. Here's my current formula:[lookup db=ShipCosts.db&lookInField=weight&value=[math][lineitems]([lookupdb=pricing.db&lookInField=sku&value=[sku]&returnField=weight]*[quantity])+[/lineItems]0[/math]&returnField=[shipVia]]I'm trying to multiply the weight of an item by the quantity selected forthat item. I'm moving to my development server to continue to play with it,but wonder if anyone can quickly spot the flaw in my formula?Thanks,Dale Stokdykdstokydk@dvs.mv.com Dale Stokdyk

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:

Founditems context returning only 1 item (1997) docs for WebCatalog2 (1997) Separate SSL Server (1997) SendMail question (2004) wrong input values? (1997) Checkboxes (1998) SMSI - support needed please ... (2003) WebCat & Liststar (1997) Multiple Passwords (1997) WebCat2 beta 11 - new prefs ... (1997) Exclamation point (1997) How does WebCatalog search the database? (1997) Search group and ww (2003) can WC render sites out? (1997) database visibility (2000) WCS Newbie question (1997) OT: Calling All Freelance Programmers in PDX (2000) Buying sans cart (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) emailer settings and control questions (1997)