Re: the dreaded unitShipCost

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53841
interpreted = N
texte = Stuart Tremain wrote: > Simple, here is an example of how we have a formulas.db for each site, > the db is placed at the root level of the site: > > Name Formula > price [lookup db=/[ThePath]/eStore/data/ > products.db&lookInField=sku&value=[sku]&returnField=price] > taxRate [lookup db=/[ThePath]/eStore/ > TaxRates.db&lookInField=Tax&value=[ShipVia]&returnField=taxRate¬Found > =0.00] > shipCost [lookup db=/[ThePath]/eStore/data/ > delivery.db&lookInField=sku&value=[header1]&returnField=price] > unitShipCost [lookup > db=products.db&lookInField=sku&value=[sku]&returnField=unitShipCost] Stuart, this is all well and good but all your pages with the addlineitems contexts are in the root also, right?. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design WWW Developer / Consultant <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 email:> dbrooke(AT)euca.us Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  2. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  3. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  4. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  5. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  6. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  7. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  8. Re: the dreaded unitShipCost ( John Peacock 2003)
  9. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  10. Re: the dreaded unitShipCost ( Alain Russell 2003)
  11. Re: the dreaded unitShipCost ( Alain Russell 2003)
  12. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  13. Re: the dreaded unitShipCost ( John Peacock 2003)
  14. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  15. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  16. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  17. Re: the dreaded unitShipCost ( Donovan Brooke 2003)
  18. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  19. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  20. Re: the dreaded unitShipCost ( Tim Robinson 2003)
  21. Re: the dreaded unitShipCost ( "Andrew Simpson" 2003)
  22. Re: the dreaded unitShipCost ( Stuart Tremain 2003)
  23. the dreaded unitShipCost ( "Andrew Simpson" 2003)
Stuart Tremain wrote: > Simple, here is an example of how we have a formulas.db for each site, > the db is placed at the root level of the site: > > Name Formula > price [lookup db=/[ThePath]/eStore/data/ > products.db&lookInField=sku&value=[sku]&returnField=price] > taxRate [lookup db=/[ThePath]/eStore/ > TaxRates.db&lookInField=Tax&value=[ShipVia]&returnField=taxRate¬Found > =0.00] > shipCost [lookup db=/[ThePath]/eStore/data/ > delivery.db&lookInField=sku&value=[header1]&returnField=price] > unitShipCost [lookup > db=products.db&lookInField=sku&value=[sku]&returnField=unitShipCost] Stuart, this is all well and good but all your pages with the addlineitems contexts are in the root also, right?. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design WWW Developer / Consultant <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 email:> dbrooke(AT)euca.us Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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://webdna.smithmicro.com/ Donovan Brooke

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] a either fields are blank (1998) Support ?? (1997) Tax Rates (1998) multi-paragraph fields (1997) [LOOKUP] (1997) ShipCost Data Base (1998) PIXO (1997) WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997) [Fwd: Rotating Banners ... (was LinkExchange)] (1997) Payment calculator ?? (2000) [WebDNA] COMMITDATABASE in linux unix 64bits FastCGI version 8.6 (2020) WebCat2 beta 11 - new prefs ... (1997) WebCat2.0 [format thousands .0f] no go (1997) X etc.... (1999) synching databases on multiple servers (1997) Setting Cart value (2000) Solution to Back button (2000) Multi-processor Mac info ... (1997) Running 2 two WebCatalog.acgi's (1996) tracking no. of downloads (2006)