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:
Sendmail truncation in Eudora Clients (1998)
New index for docs (1997)
unique ID (1997)
why is this line in GeneralStore? (1998)
Banner Ad example (Typhoon) and WebCatalog (1997)
WebCatalog on G3 Macs? (1997)
I forgot (1998)
lineitems context in sendmail context (1998)
Search design (1997)
Protect vs Authenicate (1997)
5.0 Pricing (2003)
Running _every_ page through WebCat-error.html (1997)
[WebDNA] Combining searches with blank and zero values? (2011)
Country & Ship-to address & other fields ? (1997)
[WebDNA] Captcha question (and free code) (2009)
formulas.db ?? (1998)
PSC recommends what date format yr 2000??? (1997)
pull downs (1997)
searching with groups (1997)
webcat restarting script on Linux? (1999)