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][/for
mat]&returnField=11¬Found=nope]
However this one DOES work:
shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format
.0f][search
db=main2.txt&eqSKUdata=796819][founditems][Weight][/founditems][/search][/fo
rmat]&returnField=11¬Found=nope]
The only difference is that I am hardcoding the sku in in
eqSKUdata=796819
vs eqSKUdata=[sku]
I know the sku is getting passed into the formula.db because my price
formula works:
price [lookup
db=Main2.txt&lookInField=sku&value=[sku]&returnField=RetailPrice]
That has the [sku] varible in it!
What's the deal?
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][/for
mat]&returnField=11¬Found=nope]
However this one DOES work:
shipCost [lookup db=fed-x.db&lookInField=Lbs&value=[format
.0f][search
db=main2.txt&eqSKUdata=796819][founditems][Weight][/founditems][/search][/fo
rmat]&returnField=11¬Found=nope]
The only difference is that I am hardcoding the sku in in
eqSKUdata=796819
vs eqSKUdata=[sku]
I know the sku is getting passed into the formula.db because my price
formula works:
price [lookup
db=Main2.txt&lookInField=sku&value=[sku]&returnField=RetailPrice]
That has the [sku] varible in it!
What's the deal?
Thanks!
Brant
DOWNLOAD WEBDNA NOW!
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...