shipping help
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16353
interpreted = N
texte = I am having some difficulty with setting up S&H charges, and am hoping that someone can provide some assistance. My customer has specific S&H charges for her business, and I am trying to get WebCat to accomodate. In my shipcost.db, I have setup as follows:from to shipping 0.00 10 3.75 10.01 25 4.75 25.01 50 6.75 50.01 100 9.75 100.01 150 12.75 150.01 200 15.75The goal is to have S&H charges based upon the subtotal of the order. For instance, if the subtotal is $15.00, the shipping charges would be $4.75. To that end, I set up the following in my formulas.db:db=ShipCosts.db&lookInField=from&value=le[subTotal]&lookInField=to&value=ge[subTotal]&returnField=shipping¬Found=[math].08*[subTotal][/math]]My intent was to have WebCat look into the shipcost.db, compare the subtotal to both the to and from fields (using greater than/equals to and less than/equals to), and have it return the value from the shipping column that corresponds. The math equation at the end is for purchases over $200. Instead of a set fee, the cost is then 8% of the purchase price. Only values over $200 should not be found, and thus match the ¬Found variable. For some reason or other however, the math equation is the only one that works. No matter what the subtotal of the purchase, the shipping is always set at 8%.Obviously, there is a flaw with my syntax/reasoning. If someone could point me in the right direction, I would be greatly appreciative.Thanks in advance,Dennis
Associated Messages, from the most recent to the oldest:
I am having some difficulty with setting up S&H charges, and am hoping that someone can provide some assistance. My customer has specific S&H charges for her business, and I am trying to get WebCat to accomodate. In my shipcost.db, I have setup as follows:from to shipping 0.00 10 3.75 10.01 25 4.75 25.01 50 6.75 50.01 100 9.75 100.01 150 12.75 150.01 200 15.75The goal is to have S&H charges based upon the subtotal of the order. For instance, if the subtotal is $15.00, the shipping charges would be $4.75. To that end, I set up the following in my
formulas.db:db=ShipCosts.db&lookInField=from&value=le[subTotal]&lookInField=to&value=ge[subTotal]&returnField=shipping¬Found=
[math].08*[subTotal][/math]]My intent was to have WebCat look into the shipcost.db, compare the subtotal to both the to and from fields (using greater than/equals to and less than/equals to), and have it return the value from the shipping column that corresponds. The math equation at the end is for purchases over $200. Instead of a set fee, the cost is then 8% of the purchase price. Only values over $200 should not be found, and thus match the ¬Found variable. For some reason or other however, the math equation is the only one that works. No matter what the subtotal of the purchase, the shipping is always set at 8%.Obviously, there is a flaw with my syntax/reasoning. If someone could point me in the right direction, I would be greatly appreciative.Thanks in advance,Dennis
Dennis J. Bonsall, Jr.
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:
WebCatalog for Postcards ? (1997)
pop up building with summarize (1998)
How update the file: products.db (2000)
[cart]= (2004)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
Cyberstudio and WebDNA (1997)
problems with 2 tags (1997)
Help name our technology! (1997)
WebCat & WebTen (1997)
Here we go again... (2006)
UPS Shipping Docs (Where To Go) (1999)
PIXO (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Item counting? (1998)
Nesting Search Within ![]()
Tag? (1997)
NTbeta18 corrupted? (1997)
flushing databases (2003)
[WriteFile] problems (1997)
encryption madness (2003)
OT - ImageMagick on MacOS X (2004)