RE:formula.db problems
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 23464
interpreted = N
texte = Are you positive that the ShipToZip has been already set at this stage?Usually when people are first adding items to the cart, the ShipToZip isunknown. Since this formula only evaluates *once* at the moment an item isadded to the cart, it needs to know the ShipToZip beforehand.>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?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:
Are you positive that the ShipToZip has been already set at this stage?Usually when people are first adding items to the cart, the ShipToZip isunknown. Since this formula only evaluates *once* at the moment an item isadded to the cart, it needs to know the ShipToZip beforehand.>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?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/
PCS Technical Support
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:
[lookup] vs. [search] (1998)
WebCat2b13MacPlugIn - more [date] problems (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
Tax Collection for Different Items (2003)
[WebDNA] [listwords] and [index] (2009)
Append..... doesn't (2000)
Re:Signal Raised (1997)
Subtotal Not Calculated on Invoice.html (1998)
passwords (2000)
need e-commerce recommendation (2004)
WebCatalog Technical Reference (1997)
PCS Frames (1997)
Resume Catalog ? (1997)
Loosing Quantity (2000)
Location of Browser Info.txt file (1997)
Help with sorting search results sorting (1998)
Navigator 4.01 (1997)
Emailer errors & disappearing messages (1998)
European Convention (2004)