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 onefor UPS that I'm having problems with. It looks like this:unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format.0f][searchdb=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=[searchdb=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 gettingpassed. When I hard code the zip code in it works fine. The strangething is that in my taxRate formula I use this same exact variable andit works. How can I get the ship to zip to get passed into myunitShipCost formula?ThanksBrant-----------------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][searchdb=main2.txt&eqSKUdata=[sku]][founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]-----------[sku] is not available to the shipCost formula, because shipCost isconsidered 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 itappliesto that particular lineitem.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Okay that helped. The first formula was for fed ex but I also have onefor UPS that I'm having problems with. It looks like this:unitShipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format.0f][searchdb=main2.txt&eqSKUdata=[sku]]
[founditems][Weight][/founditems][/search][/format]&returnField=[searchdb=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 gettingpassed. When I hard code the zip code in it works fine. The strangething is that in my taxRate formula I use this same exact variable andit works. How can I get the ship to zip to get passed into myunitShipCost formula?ThanksBrant-----------------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][searchdb=main2.txt&eqSKUdata=[sku]]
[founditems][Weight][/founditems][/search][/format]&returnField=11¬Found=nope]-----------[sku] is not available to the shipCost formula, because shipCost isconsidered 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 itappliesto that particular lineitem.Technical Support | ==== eCommerce and Beyond ====Pacific Coast Software | WebCatalog, WebMerchant,11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster,San Diego, CA 92128 | Typhoon619/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)