Re: Counting LineItems

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31799
interpreted = N
texte = 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 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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:

    
  1. Re: Counting LineItems (chas@valley.net (chas) 2000)
  2. Re: Counting LineItems (John Butler 2000)
  3. Re: Counting LineItems (chas@valley.net (chas) 2000)
  4. Re: Counting LineItems (John Butler 2000)
  5. Re: Counting LineItems (chas@valley.net (chas) 2000)
  6. Re: Counting LineItems (John Butler 2000)
  7. Re: Counting LineItems (Kenneth Grome 2000)
  8. Re: Counting LineItems (chas@valley.net (chas) 2000)
  9. Re: Counting LineItems (John Peacock 2000)
  10. Re: Counting LineItems (chas@valley.net (chas) 2000)
  11. Re: Counting LineItems (chas@valley.net (chas) 2000)
  12. Re: Counting LineItems (kalin@el.net 2000)
  13. Re: Counting LineItems (kalin@el.net 2000)
  14. Re: Counting LineItems (Kenneth Grome 2000)
  15. Re: Counting LineItems (kalin@el.net 2000)
  16. Re: Counting LineItems (kalin@el.net 2000)
  17. Re: Counting LineItems (John Butler 2000)
  18. Re: Counting LineItems (John Peacock 2000)
  19. Re: Counting LineItems (chas@valley.net (chas) 2000)
  20. Re: Counting LineItems (John Butler 2000)
  21. Re: Counting LineItems (John Butler 2000)
  22. Re: Counting LineItems (John Butler 2000)
  23. Re: Counting LineItems (John Peacock 2000)
  24. Re: Counting LineItems (chas@valley.net (chas) 2000)
  25. Re: Counting LineItems (John Butler 2000)
  26. Re: Counting LineItems (chas@valley.net (chas) 2000)
  27. Re: Counting LineItems (Brian Boegershausen 2000)
  28. Counting LineItems (chas@valley.net (chas) 2000)
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 ------------------------------------------------------------- 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/ ------------------------------------------------------------- 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/ Brian Boegershausen

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:

Using the sendmail command on CGate Pro (Unix) (2000) Replace context problem ... (1997) Not really WebCat (1997) List of WebDNA users (2002) Inventory lookup & display... (2003) Sorting Orders (1997) Requiring that certain fields be completed (1997) Hosts who have upgraded to v5.0? (2003) Emailer error 550? Never mind. (1999) RE: Languages (1997) WebCAT has the devil in it! (2003) Incrementing a number (1998) Setting Lineitems (2005) netscape and missing url in error redirect (2001) Re:Variable Math (1998) Can't access [OrderFile] OSXS WC4 (2000) merchant accts. (1997) [Sum] function? (1997) Universal root for WC errors? (1997) 2.0Beta Command Ref (can't find this instruction) (1997)