Re: Discounts
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 36554
interpreted = N
texte = Nitai @ ComputerOil wrote: > > Hi all, > > I have 3 discounts stored for each item in the products.db. > > Getting the discount out of the products.db is no problem within a lineitems > context. I do a lookup with quantity and get the desired discount...BUT... > > Let say I have a items and the customer buys 20 pieces. In the products.db > the discount for 20 pieces is stored with 10%. I get this discount out but I > also get the discount for 10 pieces which is 5%. How can I only get the > discount out for 20 pieces? > > Here is the code I have used so far: > > [if (([quantity]=5) | ([quantity]>5))]is 20 > 5?> [then] > You get 10% > [/then] > > [if (([quantity]=10) | ([quantity]>10))]is 20 > 10?> [then] > You get 15% > [/then] > > [if (([quantity]=20) | ([quantity]>20))]is 20 = 20?> You get 20% > [/then] > > [/if] > > [/if] > > [/if]The point is that each of these [if] statements is independent of the others. If you want to use [if] then you need to nest the 2nd two [if] statements so that only one fires.[if...] [else] [if...] [else] [if...] [/if] [/else] [/if] [/else] [/if]HTHJohn Peacock-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Nitai @ ComputerOil wrote: > > Hi all, > > I have 3 discounts stored for each item in the products.db. > > Getting the discount out of the products.db is no problem within a lineitems > context. I do a lookup with quantity and get the desired discount...BUT... > > Let say I have a items and the customer buys 20 pieces. In the products.db > the discount for 20 pieces is stored with 10%. I get this discount out but I > also get the discount for 10 pieces which is 5%. How can I only get the > discount out for 20 pieces? > > Here is the code I have used so far: > > [if (([quantity]=5) | ([quantity]>5))]is 20 > 5?> [then] > You get 10% > [/then] > > [if (([quantity]=10) | ([quantity]>10))]is 20 > 10?> [then] > You get 15% > [/then] > > [if (([quantity]=20) | ([quantity]>20))]is 20 = 20?> You get 20% > [/then] > > [/if] > > [/if] > > [/if]The point is that each of these [if] statements is independent of the others. If you want to use [if] then you need to nest the 2nd two [if] statements so that only one fires.[if...] [else] [if...] [else] [if...] [/if] [/else] [/if] [/else] [/if]HTHJohn Peacock-- John Peacock Director of Information Research and Technology Rowman & Littlefield Publishing Group 4720 Boston Way Lanham, MD 20706 301-459-3366 x.5010 fax 301-429-5747------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Peacock
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:
2 easy questions re: [showif] and [sendmail] (1997)
My X-Mas Wish (1999)
Emailer setup (1997)
[group] ? (1997)
RE: Renaming textA (1998)
taxRate is fine but taxTotal isn't (1997)
SSL PROBLEM (1999)
Hiding HTML and breaking the page (1997)
[WebDNA] WebDNA and MAMP/Apache (Mac) (2018)
Configuration Q (1998)
WebCatalog template cache (1998)
5.0 feature request: Sort for ListWords (2001)
mass mailing (1998)
Sitebuilder (2004)
requiring form fields? (2000)
Variables for chat (1997)
Loop to write data? (2003)
Add - optional parameters textA=.... (1997)
Hosting Services (1999)
Capturing the referring site (1999)