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:
TCP Connect (1999)
reverse loops (1998)
DB Size - MAX (2004)
Comments in db? (1997)
NTbeta18 corrupted? (1997)
wrong input values? (1997)
WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997)
WebCat and image maps (1997)
process SSI (1998)
Who is doing sign-ups-got it (1998)
alternatives for WebDNA (2004)
[SearchString] usage (1997)
WebCat2b12 CGI Mac - [shownext] problem (1997)
Rumpus & WebCat (1998)
[WebDNA] Quick grep question (2009)
[sendmail] and [formvariables] (1997)
passing the variable (1999)
Review comparison by PC Magazine: Open for On-line Business (1997)
Displaying search results in a new frameset (1997)
WCf2 and nested tags (1997)