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 | Typhoon619/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 | 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:
Trouble with formula.db (1997)
READFILE command? (1998)
convert WebDNA from flat file to MySQL (2006)
[WebDNA] sales tax on shipping (2008)
Form and Context Searching -Hideif/Showif (2000)
Return records from another (1997)
taxRate is fine but taxTotal isn't (1997)
Search / Results on unrecognized characters (2003)
[ShowCart]-- was ThankYou page problems (1997)
2.01 upgrade problems (1997)
WebDelivery: One step closer !! (1997)
emailer on Windows Beta 18 (1997)
Modifying Carts (1999)
WebCatalog stalls (1998)
webstar/webcat monitoring aides? (1999)
includes and cart numbers (1997)
new WebDNA 5 command reference (2003)
[OT] 'Email this story to a friend' (2003)
Protect vs Authenicate (1997)
Cart sweeper (2000)