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:

Speed Optimization - Mac (1997) [tcpsend] (2001) [showif]/[hideif] question (1997) Bug Report, maybe (1997) Re:Dumb Question about Docs (1997) Security Tip (1996) Dubble Sku's in a Database (1999) Failure to document significant changes ... (2000) [ConvertChars] problem (1997) Orderfile (2005) taxTotal, grandTotal (1997) 100% cpu load (2006) Sort Issue? (2000) listfiles shows invisible files ... (1999) WebCatalog.acgi quitting with error Type 2 (1998) THANKS (1997) Share cost of training videos! (1998) Help with Repost Data msg from form (1997) New public beta available (1997) [authenticate] was [TIME] not working (2007)