Re: Counting LineItems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31870
interpreted = N
texte = check the sytax of the tag [lookup] and the context [showif] in the docs. Your code for the first part of that price formula looks wacky. Probably you meant -[showif [basket]=1]price=15[/showif]...but also note that you really want-[showif [basket]=1]15[/showif](you don't have to put price= in those showifs. That is what the formula is already trying to do.)so the whole formula.db record would be something like----- Name
Formula price[showif [basket]<3]15[/showif][hideif [basket]>5][showif [basket]>2]12[/showif][/hideif][showif [basket]>5]10[/showif] ---- (this would do what you asked for except for that last line - And if there were 4 or 5 line items the price would hold to $12 a CD. )-Johnchas wrote:> 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/ ------------------------------------------------------------- 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:
check the sytax of the tag [lookup] and the context [showif] in the docs. Your code for the first part of that price formula looks wacky. Probably you meant -[showif [basket]=1]price=15[/showif]...but also note that you really want-[showif [basket]=1]15[/showif](you don't have to put price= in those showifs. That is what the formula is already trying to do.)so the whole formula.db record would be something like----- NameFormula price[showif [basket]<3]15[/showif][hideif [basket]>5][showif [basket]>2]12[/showif][/hideif][showif [basket]>5]10[/showif] ---- (this would do what you asked for except for that last line - And if there were 4 or 5 line items the price would hold to $12 a CD. )-Johnchas wrote:> 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/ ------------------------------------------------------------- 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/
John Butler
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:
WebCatb15 Mac CGI -- [purchase] (1997)
[movefile] (1999)
Cannot get subtotal to work (1997)
[Webcat 2]Next (1997)
What am I missing (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Summing fields (1997)
[WebDNA] Calculate Cube root (2012)
Possible Macv2.1b2 Merge Bug (1997)
ShipCost Data Base (1998)
WebCat on 10.0.4 - iTools 6.0 (2001)
[WebDNA] Quick sort/results grouping Q (2008)
SOP for WebDNA talk - MSNBot Crashing (2004)
WebCat2 - Getting to the browser's username/password data (1997)
Using Applescript to process WebCatalog functions (1998)
RE: Languages (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
SendMail - sending message to more than one person from (2006)
why is this line in GeneralStore? (1998)
sort problems....bug or brain fart? (1997)