Re: Counting LineItems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31865
interpreted = N
texte = Wow, Thanks Brian, I'm half way there......I've put a header in the shoppingcart.tpl that calculates lineitems and quantities. I just used [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] in the pricebreak.inc and call view the text to see if its working.[Include file=pricebreak.inc] [basket] great!Now, I'm stumped because I know that [basket] returns the appropriate value and I tried the example below in the formulas.db....not happening... ---- Name Formula price [lookup showif [basket]=1]price=15[/showif][showif [basket]=2]price is 15[/showif][showif [basket]=3]price = 12[/showif] ---- essentially I'm looking for the easiest way to build a case/if function to plug in to [price]Charley Conquest Fresh Music --- You wrote: I think there is a tag [totallineitems] or something to that nature, I forget. I have also used in the past [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] You can also use this to set a header, then use the header in you formulas.db to do your calculation. [showif [header21]=1]price is 15[/showif] [showif [header21]=3]price is 12[/showif] etc----- Original Message ----- From: chas
To: WebCatalog Talk Sent: Friday, May 12, 2000 3:20 PM Subject: Counting LineItems 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 --- end of quote ---------------------------------------------------------------- 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:
Wow, Thanks Brian, I'm half way there......I've put a header in the shoppingcart.tpl that calculates lineitems and quantities. I just used [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] in the pricebreak.inc and call view the text to see if its working.[Include file=pricebreak.inc] [basket] great!Now, I'm stumped because I know that [basket] returns the appropriate value and I tried the example below in the formulas.db....not happening... ---- Name Formula price [lookup showif [basket]=1]price=15[/showif][showif [basket]=2]price is 15[/showif][showif [basket]=3]price = 12[/showif] ---- essentially I'm looking for the easiest way to build a case/if function to plug in to [price]Charley Conquest Fresh Music --- You wrote: I think there is a tag [totallineitems] or something to that nature, I forget. I have also used in the past [text]basket=[math]0[lineitems]+[quantity][/lineitems][/math][/text] You can also use this to set a header, then use the header in you formulas.db to do your calculation. [showif [header21]=1]price is 15[/showif] [showif [header21]=3]price is 12[/showif] etc----- Original Message ----- From: chas To: WebCatalog Talk Sent: Friday, May 12, 2000 3:20 PM Subject: Counting LineItems 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 --- end of quote ---------------------------------------------------------------- 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:
expired beta (1997)
Can you do this??? and other stuff (1997)
New command suggestion (1997)
[OT} DNSTrans? (2004)
Using Eudora instead of Emailer, and cron facility (1998)
Looking up two prices in database? (1997)
New index for docs (1997)
ListVariables Problem (2003)
RE: Web*SSL and WebCatalog (1997)
Re:Variable Math (1998)
unsubscribe (1997)
Permissions with 3.06 Linux (2000)
[WebDNA] configuring 5.1 with apache 2? (2008)
Separate SSL Server (1997)
Generating unique SKU from [cart] - Still Stumped... (1997)
Summing fields (1997)
How do you TEAM Code? (2004)
Unknown error: OrderNotCreated (1997)
WebCat2.0 [format thousands .0f] no go (1997)
multiple price line in formula.db (2004)