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:
Default contains WEBDNA (1998)
Extended [ConvertChars] (1997)
[GREP] Why is the dash invalid? (2002)
Help name our technology! (1997)
Multiple download orders of the same product? (1997)
Moving files from one server to another... (2001)
errors 550, and 108 (1998)
F3 crashing server (1997)
Emailer help....! (1997)
[WebDNA] How to use [function] (2012)
setting username and password using a form. (2000)
[WebDNA] [announce] WebDNA 6.2.1x (2012)
Problem displaying search result (1997)
Pithy questions on webcommerce & siteedit (1997)
WC2.0 Memory Requirements (1997)
Cart # Starting at 1000 (2000)
Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997)
PCS Frames (1997)
WebCat2 - Getting to the browser's username/password data (1997)
My Eyes doth deceive me (2002)