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:
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)