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:NameFormulaprice[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/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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:
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:NameFormulaprice[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/>>RegardsStuart Tremainidfk web developments114a/40 yeo street neutral bay 2089 australiat +612 9908 2134f +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)