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:
Math Function (1997)
Waitfor(ever) (2002)
Search minus first found (1999)
Share Snippet? (1999)
[WebDNA] New Mountain Lion OSX Server (2013)
CR's (2003)
Upgrading old WebCat Database Files (1997)
state? (2004)
WebCatalog vs WebDNA (2002)
A few questions. . . (1997)
Emailer errors (1997)
I give up!! (1997)
$purchase WITHOUT creditcar (1997)
Re:2nd WebCatalog2 Feature Request (1996)
Nested tags count question (1997)
unable to launch acgi in WebCat (1997)
WebCatalog2 Feature Feedback (1996)
WebCat for Unix?? (1997)
What really killed WebDNA? (2007)
Linux ODBC and the ODBC Bridge (2000)