Re: Counting LineItems
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31933
interpreted = N
texte = Ahh such happiness!!.... got it to fire properly by putting the formula in the template. [math]zprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math] zprice=[zprice]and adding [zprice] to the lineitem
[format 6.2f][zprice][/format] | [format 6.2f][price][/format] | [zprice] calculates as expected..Great! [price] returns 17.77this last day and a 1/2 i could only return the final formula value (15 - 3 - 2 10) no matter what the quantity of [basket] when:Name
Formula price[math]15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math]always returns 10 So i think there is some hinkyness in my calling the formula above.. so I added another entry into formula.db and tried:nameformula tprice[math]tprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math]and got [format 6.2f][zprice][/format] | -this yielded $15.00 with 1 line - success [format 6.2f][tprice][/format] | -this yielded $00. 00 with 1 line - then tried nameformula tprice[math]15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math][format 6.2f][zprice][/format] | -this yielded $15.00 with 1 line - success [format 6.2f][tprice][/format] | -this yielded $00. 00 with 1 line - I'am missing something essential... John P and John B thanks so much for the help! Charley Conquest Fresh Music-- You wrote: Chas,did you try John Peacock's neat formula? Does it behave now?If not then break the problem down into smaller pieces. Put that formula code in the template itself, but assign a variable to the price value so you can see what it is later down. For example put this directly into the template-basket=[basket]
[math]zprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math] zprice=[zprice]see if you get what you think you should get.Now also see if you can get *any* formula to work. Try- ---- NameFormula price17.77 --- 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:
Ahh such happiness!!.... got it to fire properly by putting the formula in the template. [math]zprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math] zprice=[zprice]and adding [zprice] to the lineitem [format 6.2f][zprice][/format] | [format 6.2f][price][/format] | [zprice] calculates as expected..Great! [price] returns 17.77this last day and a 1/2 i could only return the final formula value (15 - 3 - 2 10) no matter what the quantity of [basket] when:NameFormula price[math]15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math]always returns 10 So i think there is some hinkyness in my calling the formula above.. so I added another entry into formula.db and tried:nameformula tprice[math]tprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math]and got [format 6.2f][zprice][/format] | -this yielded $15.00 with 1 line - success [format 6.2f][tprice][/format] | -this yielded $00. 00 with 1 line - then tried nameformula tprice[math]15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math][format 6.2f][zprice][/format] | -this yielded $15.00 with 1 line - success [format 6.2f][tprice][/format] | -this yielded $00. 00 with 1 line - I'am missing something essential... John P and John B thanks so much for the help! Charley Conquest Fresh Music-- You wrote: Chas,did you try John Peacock's neat formula? Does it behave now?If not then break the problem down into smaller pieces. Put that formula code in the template itself, but assign a variable to the price value so you can see what it is later down. For example put this directly into the template-basket=[basket]
[math]zprice=15[ShowIf [basket]>2]-3[/showif][ShowIf [basket]>5]-2[/ShowIf][/math] zprice=[zprice]see if you get what you think you should get.Now also see if you can get *any* formula to work. Try- ---- NameFormula price17.77 --- 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:
shipCost (1998)
HELP WITH DATES (1997)
writefiles (1999)
Multiple Newcarts (1996)
when is date system date or order date? (1997)
[WebDNA] Re-sending email (2018)
NT or Mac (1998)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Banner Ads (2000)
TCPConnect misbehavin' for me. (2000)
WebCat2.0 acgi vs plugin (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
RE: redirect with more than 256 characters (1999)
Forumulas.db & Variables (2002)
Online reference (1997)
Merging databases (1997)
WebCat2 several catalogs? (1997)
A little help on e-mail (HELP!!! :-) ) (1998)
WC TableGrinder (1997)
ANN: Strategic Partnership with BuyStream Announced. (2000)