Re: Pricing based on quantity
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26276
interpreted = N
texte = on 1/19/00 7:45 PM, Brian Boegershausen at
said to me:> You need to set up prices depending on the quantity in the database.> You coiuld have price 1 price 2 etc in your products.db> then in your formaulas.db use showifs to pick the price depending on the> quanitiy.Can someone please help me with the following formula?In my products database, I set up [price_1], [price_2]...[price_8] for eachof the products. The pricing of the product is determined by the total number of items in theshopping cart. It does not matter how many of each item, just the totalnumber in the entire cart. (This store is for videos, where each of theproducts cost the same amount, but the more you buy, the less they cost perpiece).In the formulas database, I want to set it up so that once it figures outthe number of items, it picks the correct price.For instance, if there are three items in the basket, then the price peritem is [price_3]. If there are four items, the price is [price_4].How should this formula be set up?Thanks for any help.-- Jimi SweetBig City BabyVisit http://www.jimisweet.com/Visit http://www.bigcitybaby.com/-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Associated Messages, from the most recent to the oldest:
on 1/19/00 7:45 PM, Brian Boegershausen at said to me:> You need to set up prices depending on the quantity in the database.> You coiuld have price 1 price 2 etc in your products.db> then in your formaulas.db use showifs to pick the price depending on the> quanitiy.Can someone please help me with the following formula?In my products database, I set up [price_1], [price_2]...[price_8] for eachof the products. The pricing of the product is determined by the total number of items in theshopping cart. It does not matter how many of each item, just the totalnumber in the entire cart. (This store is for videos, where each of theproducts cost the same amount, but the more you buy, the less they cost perpiece).In the formulas database, I want to set it up so that once it figures outthe number of items, it picks the correct price.For instance, if there are three items in the basket, then the price peritem is [price_3]. If there are four items, the price is [price_4].How should this formula be set up?Thanks for any help.-- Jimi SweetBig City BabyVisit http://www.jimisweet.com/Visit http://www.bigcitybaby.com/-------------------------------------------------------------Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server.To end your Mail problems go to .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
Jimi Sweet
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:
Re:[off] Promotions Co? (1997)
Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)
Unknown error: OrderNotCreated (1997)
newbie question about zip code search (2003)
WebCat vs. ASP (1999)
WebDNA 4.5 not starting on boot? (2002)
"Advanced" Search Algorithm (2008)
Sorting by date (1997)
WebCatalog [FoundItems] Problem - LONG - (1997)
Grouping search fields, etc. (1997)
WebCat Admin access w/ClearlyHome p.i. (1997)
no [include]s with encryption? (1998)
RE: Can a database get stomped by simultaneous access? (1997)
IIS4/WebCat3.0 Authentication (1999)
carriage returns in data (1997)
Open Databases on Restart (1999)
WebCatalog for guestbook ? (1997)
Email Spam a bit of Hell (2004)
AAAH: stupid sendmail (2001)
referrer and no caches (1997)