RE:formula.db problems

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 23456
interpreted = N
texte = Okay that helped. The first formula was for fed ex but I also have one for UPS that I'm having problems with. It looks like this:unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=[search db=zones.txt&leFROMdatarq=[ShipToZip]&geTOdatarq=[ShipToZip]&max=1][foundItems][zone][/foundItems][/search]¬Found=0]The problem I am having with this one is the [ShipToZip] isn't getting passed. When I hard code the zip code in it works fine. The strange thing is that in my taxRate formula I use this same exact variable and it works. How can I get the ship to zip to get passed into my unitShipCost formula?Thanks Brant----------------- Can anyone tell me why this formula in my formula.db isn't working?shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]----------- [sku] is not available to the shipCost formula, because shipCost is considered a header ('global' to the entire order), so it has no idea *which* sku from the many lineitems you want applied to the formula. [SKU] is available when calculating the unitShipCost formula, because it applies to that particular lineitem. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. RE:formula.db problems (PCS Technical Support 1999)
  2. RE:formula.db problems (es-sleestak 1999)
Okay that helped. The first formula was for fed ex but I also have one for UPS that I'm having problems with. It looks like this:unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=[search db=zones.txt&leFROMdatarq=[ShipToZip]&geTOdatarq=[ShipToZip]&max=1][founditems][zone][/foundItems][/search]¬Found=0]The problem I am having with this one is the [ShipToZip] isn't getting passed. When I hard code the zip code in it works fine. The strange thing is that in my taxRate formula I use this same exact variable and it works. How can I get the ship to zip to get passed into my unitShipCost formula?Thanks Brant----------------- Can anyone tell me why this formula in my formula.db isn't working?shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format .0f][search db=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]----------- [sku] is not available to the shipCost formula, because shipCost is considered a header ('global' to the entire order), so it has no idea *which* sku from the many lineitems you want applied to the formula. [SKU] is available when calculating the unitShipCost formula, because it applies to that particular lineitem. Technical Support | ==== eCommerce and Beyond ==== Pacific Coast Software | WebCatalog, WebMerchant, 11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, San Diego, CA 92128 | Typhoon 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/ es-sleestak

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:

Searching multiple Databases (1997) Generating Report Totals (1997) Faxing orders in place of email (1997) multiple credit card merchant accounts/processors (1997) Inventory Adjustment (2000) splitting numbers in webDNA? (1997) Math (1997) WebDNA 4.5.1 on Apache 2.x. (2004) [OT] Certs (2002) Bug Report, maybe (1997) taxTotal, grandTotal (1997) [format 40s]text[/format] doesn't work (1997) New WebCatalog Version !!! (1997) 2.1 bugs left over from beta cycle (1998) Help Wanted (2005) Feature req. (2002) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) Permission denied? (2004) Can't use old cart file (was One more try) (1997) Maybe minor bug report (1997)