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:

Search design (1997) Generating Report Totals (1997) Displaying photo attached to first record (1997) what servers are supported for Typhoon? (1997) Help name our technology! I found it (1997) RE: [WebDNA] Basic Search (2008) If Empty ? (1997) Searching Multiple DBs (1997) Extended [ConvertChars] (1997) Migrating to NT (1997) This message couldn't reach the list! (multi-column layout ofsearch results) (1998) For those of you not on the WebCatalog Beta... (1997) automating txt downloads for conversion to webcat db (2006) How true is this? (1999) Webcatalog quitting (1997) [WebDNA] PayPal Instant Payment Notification Guide (2009) Running 2 two WebCatalog.acgi's (1996) WebCat2 - storing unformatted date data? (1997) PCS Frames (1997) unix permissions theory applied to db security? Or...? (2000)