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:
form crasehes server (1997)
[shipTotal] or [shippingTotal] ??? (1998)
listfile options (1997)
Summary search -- speed (1997)
Speeding up my [showif] performance (1999)
WebDNA tags in WebMerchant email templates ... (1997)
[REDIRECT] (1999)
math problems (2000)
Hiding HTML and breaking the page (1997)
Multiple catalog databases and showcart (1997)
PIXO (1997)
Document Contains No Data! (1997)
How big can WebCat go? (1999)
carriage returns in data (1997)
emailer (1997)
Removing [showif] makes a big difference in speed (1997)
[protect] on NT? (1997)
Weird bug, or is there something amiss? (1997)
OSX and iTools installation (2000)
Copyright that puppy (1998)