Shipping Method: > [shipVia]=UPSGround]selected[/showif]>UPS Ground > [shipVia]=USPSPriorityMail(USOnly)]selected[/showif]>USPS Priority Mail > (US ONLY) > [shipVia]=USPS(Book)]selected[/showif]>USPS (Book) > [shipVia]=USPS(Surface)]selected[/showif]>USPS (Surface) VALUE=Subscription [showif > [shipVia]=Subscription]selected[/showif]>Subscription > > > > > ShipMethod ShipCost > UPSGround 4.50 > USPSPriorityMail(US ONLY) 4.50 > USPS(Book) 3.50 > USPS(Surface) 4.50 > Subscription 0.00 > > > > Name Formula > price [lookup > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price] > taxRate [lookup > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun > d=0.00] > shipCost [lookup > db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost] > unitShipCost [lookup > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost] > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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: popup? I think that needs to happen before the formula for shipCost kicks in. Otherwise I don't see the problem either.-JohnBob McPeak wrote:> Hey Guys- > > I'm bugging out on this one. I can't see why my [ShippingTotal] won't > pick up the ShipMethod base rate from my ShipCosts.db. I've pasted all > the parts below for inspection. A fresh set of eyes might pick > something up that I just can't see. Any help is greatly appreciated. > Thanks. > > > > > [shipVia] Shipping & > Handling $[shippingTotal] > > > > p>NOTE: If you have > ONLY
> Shipping Method: > [shipVia]=UPSGround]selected[/showif]>UPS Ground > [shipVia]=USPSPriorityMail(USOnly)]selected[/showif]>USPS Priority Mail > (US ONLY) > [shipVia]=USPS(Book)]selected[/showif]>USPS (Book) > [shipVia]=USPS(Surface)]selected[/showif]>USPS (Surface) VALUE=Subscription [showif > [shipVia]=Subscription]selected[/showif]>Subscription > > > > > ShipMethod ShipCost > UPSGround 4.50 > USPSPriorityMail(US ONLY) 4.50 > USPS(Book) 3.50 > USPS(Surface) 4.50 > Subscription 0.00 > > > > Name Formula > price [lookup > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=price] > taxRate [lookup > db=TaxRates.db&lookInField=State&value=[ShipTostate]&returnField=taxRate¬Foun > d=0.00] > shipCost [lookup > db=ShipCosts.db&lookInField=ShipMethod&value=[shipVia]&returnField=ShipCost] > unitShipCost [lookup > db=fitproducts.db&lookInField=sku&value=[sku]&returnField=unitShipCost] > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/
John Butler
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:
pc (1997) Reading through the Order File (1999) Help name our technology! I found it (1997) Include a big block of text (1997) Are Talk List Archives off line (2000) Emailer Timing out (1999) mySQL/OSX (2001) WebDNA Verison 4.5 will Not Restart! This SUCKS! (2002) Summing fields (1997) Out of the woodwork (2007) Re1000001: Setting up shop (1997) Nested tags count question (1997) WC2b12: Yes, Formulas.db is for real (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) mail on NT (1998) multiple search commands (1997) Test (2004) Fw: Linux w/ apache (2000) Emailer Problem (2000) Using [Include] Context (1999)