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:
More DateMath problems (1997) Date/Time format problems (1997) can anyone confirm this behavior? (2003) Errata: WCS Newbie question (1997) off topic - dna snipets (1997) taxTotal (1997) Migrating to NT (1997) [WebDNA] some tests (2011) Site Test Please [OT] (2005) WebMerchant and PCAuthorize (1998) [WebDNA] Candidate versions release (2010) Bug? (1997) HTML tags inside textarea (2000) Too Much Rootbeer Free Offer (1997) Kaaaaahhhhhhhnnnnnnn! (1997) several .hdr files with one db file? (1999) about this server and links to who (1997) Error Log with Linux? (2000) How many Databases can I open? (2003) Word search (1997)