Re: Formulas.db / Quantity Discount problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 16793
interpreted = N
texte = >This works when I enter it on the invoice.tmpl page: >[math][lookup >db=z-b.db&lookInField=sku&value=[sku]&returnField=peritemprice][showif >[quantity]>[pricebreakpoint]]-[lookup >db=z-b.db&lookInField=sku&value=[sku]&returnField=discountammount][/showif]0+0[/ >math]Is pricebreakpoint available as a variable when you add to the cart? Is discountammount the true spelling of that field?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:
>This works when I enter it on the invoice.tmpl page: >
[math][lookup >db=z-b.db&lookInField=sku&value=[sku]&returnField=peritemprice][showif >[quantity]>[pricebreakpoint]]-[lookup >db=z-b.db&lookInField=sku&value=[sku]&returnField=discountammount][/showif]0+0[/ >math]Is pricebreakpoint available as a variable when you add to the cart? Is discountammount the true spelling of that field?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/
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:
Something Simple (1998)
UPPERCASE (1997)
SET (1998)
Tags on root directory files? (1998)
File Upload (1997)
emailer (1997)
Append..... doesn't (2000)
add line item context and showitems (1998)
[/application] error? (1997)
Satisfy Me ! was: Why can't support be satisfying to purchasers? (2000)
RE: Formulas.db + Users.db (1997)
Help- Spam Bots are spamming my site. (2007)
[format xs] freeze (1997)
WCS Newbie question (1997)
Snake Bites (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
select multiple (1997)
Developer Edition - Connection Limit (2006)
PCS Frames (1997)
range vs greater than/less than (2003)