Re: the dreaded unitShipCost

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 53840
interpreted = N
texte = 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: NameFormula 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] On Thursday, November 6, 2003, at 08:44 AM, Donovan Brooke wrote: > Stuart Tremain wrote: > >> Using v5 with sandboxes will give you the desired result of specific >> formulas dbs, so that will get you around specifying the db. > > Huh?, in who's dreams? :-) > > 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/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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)
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: NameFormula 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] On Thursday, November 6, 2003, at 08:44 AM, Donovan Brooke wrote: > Stuart Tremain wrote: > >> Using v5 with sandboxes will give you the desired result of specific >> formulas dbs, so that will get you around specifying the db. > > Huh?, in who's dreams? :-) > > 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/ > > Regards Stuart Tremain idfk web developments 114a/40 yeo street neutral bay 2089 australia t +612 9908 2134 f +612 9908 4837 ------------------------------------------------------------- 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/ Stuart Tremain

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:

ShipCost Data Base (1998) REDIRECT (2001) Configuring E-mail (1997) Assigning carts (1998) [WebDNA] fastcgi 7+ & [cart]? (2010) Resume Catalog ? (1997) [BoldWords] WebCat.acgib15Mac (1997) WebTen? (1997) No Access warning when caching HTML files (1997) Can ShowNext do this? (2000) Order not created error (1997) WebCatalog.acgi quitting with error Type 2 (1998) Speed Optimization - Mac (1997) [thisurl] (2004) off topic - dna snipets (1997) Caching [include] files ... (1997) Looking up two prices in database? (1997) searching a range -still don't get it (2000) WC TableGrinder (1997) Next (1997)