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/------------------------------------------------------------- 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:[setheader] doing what it should. Here it is: Any Ideas?[SetHeader cart=[cart] ]shipVia=[url] [__shipVia][/url]&shipToState=[url] [__shipToState][/url]&CartIPAddress=[ipaddress] [/SetHeader] John Butler wrote: > > unitShipCost = price per unit (can be in catalog.db or formula.db) > ShipCost = fixed price per order (can be in formula.db or form variable) > ShippingTotal= sum of (unitShipCost * qty) plus ShipCost for order > -(coutesy of John Peacock) > > I assume you are getting the orderfile header shipVia a value equal to what was > selected with the popup? I think that needs to happen before > the formula for shipCost kicks in. > Otherwise I don't see the problem either. > > -John > > Bob 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/------------------------------------------------------------- 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/
Bob McPeak
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:
ShowIf variables (1997) WebCatalog can't find database (1997) Bug Report, maybe (1997) [WebDNA] reverse rank=off (2008) Summing fields (1997) Summ=T Problem (1997) Webcat & MySQL Stored Procedures question -again (2005) catagories (1997) Search in 2 or more catalogs (1997) New Mac Public Beta Available (1997) Nested Loops and SHOWIFs (1997) Size limit for tmpl editor ? (1997) Lookup Notfound (1998) Highlighting words found in a keyword search (2003) Database location (2002) Trouble with formula.db (1997) [WebDNA] grep question (2009) Multiple Pulldowns (1997) Forcing a NEWCART (1997) reporting commands (2001)