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:
HELP WITH DATES (1997) Country & Ship-to address & other fields ? (1997) Email notification to one of multiple vendors ? (1997) I have observed and I am gone. (1998) Message Boards (2003) AJAX with WebDNA (2006) WebCat2 - Getting to the browser's username/password data (1997) [WebDNA] Passing a text variable via copyfile (2019) Silly date question (2006) [convertChars] and in a textarea on a form (1998) Refreshing document (2000) math on date? (1997) Requiring that certain fields be completed (1997) TCPConnect and Sandbox (2003) all records returned. (1997) Another question (1997) WebCatalog for Postcards ? (1997) emailer settings and control questions (1997) Some Advise needed (1997) Netscape Communicator 4 chops off URLs (was No Data) (1997)