Counting LineItems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31798
interpreted = N
texte = Hi All,I'm just starting to use Webcatalog 3.08 on a Mac (OS-9) with Webstar 4.2. Based on the tea room I am selling compact discs. Every compact disc has a unique name in the db. Every CD has a default [Price] value of $15. I want to calculate a price based on quantity discounts. So if someone buys 1 CD (1 lineitem) the price is $15. If they buy 3 CD's (3 lineitems) , I want the price to go to $12 a CD ($36). If they buy 6 (6 lineitems), I want the price to go to $10 a CD ($60). And if there were 4 or 5 line items the price would hold to $12 a CD.I believe I need to find the value of the number of lineitems, and use this value [xxx] in a lookup to the formula.db. Before I go mucking about, could someone steer me in the right direction on this?Charley Conquest Fresh Music chas@valley.net ------------------------------------------------------------- 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:
Hi All,I'm just starting to use Webcatalog 3.08 on a Mac (OS-9) with Webstar 4.2. Based on the tea room I am selling compact discs. Every compact disc has a unique name in the db. Every CD has a default [Price] value of $15. I want to calculate a price based on quantity discounts. So if someone buys 1 CD (1 lineitem) the price is $15. If they buy 3 CD's (3 lineitems) , I want the price to go to $12 a CD ($36). If they buy 6 (6 lineitems), I want the price to go to $10 a CD ($60). And if there were 4 or 5 line items the price would hold to $12 a CD.I believe I need to find the value of the number of lineitems, and use this value [xxx] in a lookup to the formula.db. Before I go mucking about, could someone steer me in the right direction on this?Charley Conquest Fresh Music chas@valley.net ------------------------------------------------------------- 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/
chas@valley.net (chas)
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:
random .inc files pulled and placed (2002)
addlineitem mystery (2003)
Looking up two prices in database? (1997)
listfields question (2005)
Frames and WebCat (1997)
Snake Bites (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Progress !! WAS: Trouble with formula.db (1997)
WebCatb15 Mac CGI -- [purchase] (1997)
For those of you not on the WebCatalog Beta... (1997)
autosensing lanague selection (1997)
Emailer Problem (1998)
newbie question about zip code search (2003)
[OT] SubserviantChicken.com (2004)
Sorting (2005)
PROBLEM (1997)
What to do... (2000)
replace problem (1999)
New commands in Final candidate (1997)
Re:Merging databases (1997)