Re: Custom formulas.db
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21859
interpreted = N
texte = Well I wish I could have settled the great debate, but I decieded to set the formulas in the template. (mostly because I wasn't sure on syntax to call a formula from a search or lookup, and I was sort of pressed for time). However, I created a new problem for myself. I have 2 embedded searches One that calculates the total for pice based ship totals (it also sets this number as header1) and one that calculates the ship total for weight ship totals ( it sets this number as header2). The problem is Neither of these headers will be available until the next page. And the returned values are only available within the found items and search loops. So Know I need to calculate [GrandTotal] wich If I was doing it on the next page would be [math][grandtotal]+[header1]+[Header2][/math].Is there a way to make the values returned by the embedded searchs available on the same page but outside their found items loops. Or do I have to run both searches twice?>>Yes, you may use the formulas.db to store as many special formulas as you >>wish! >> >>What's more, when you retrieve those 'special' formulas from the >>formulas.db, you do NOT have to place them inside [interpret] contexts >>like you would if you stored them in any other database, because it is >>logically *assumed* that when a formula is stored in the formulas.db, it >>*must* be interpreted. > >I'm almost positive that this is not true. The equations inside >formulas.db are only used at the time when you Add, ShowCart, or Purchase. >And only specific named formulas are used. > >There's nothing stopping you from wrapping [interpret] around a [lookup] >into the formulas.db, but that's no different than putting equations >anywhere else -- there is no advantage to putting them inside formulas.db >except as a way of collecting them all in one place for easier reference. > >Technical Support | ==== eCommerce and Beyond ==== >Pacific Coast Software | WebCatalog, WebMerchant, >11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >San Diego, CA 92128 | Typhoon >619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Well I wish I could have settled the great debate, but I decieded to set the formulas in the template. (mostly because I wasn't sure on syntax to call a formula from a search or lookup, and I was sort of pressed for time). However, I created a new problem for myself. I have 2 embedded searches One that calculates the total for pice based ship totals (it also sets this number as header1) and one that calculates the ship total for weight ship totals ( it sets this number as header2). The problem is Neither of these headers will be available until the next page. And the returned values are only available within the found items and search loops. So Know I need to calculate [GrandTotal] wich If I was doing it on the next page would be
[math][grandtotal]+[header1]+[Header2][/math].Is there a way to make the values returned by the embedded searchs available on the same page but outside their found items loops. Or do I have to run both searches twice?>>Yes, you may use the
formulas.db to store as many special formulas as you >>wish! >> >>What's more, when you retrieve those 'special' formulas from the >>
formulas.db, you do NOT have to place them inside
[interpret] contexts >>like you would if you stored them in any other database, because it is >>logically *assumed* that when a formula is stored in the
formulas.db, it >>*must* be interpreted. > >I'm almost positive that this is not true. The equations inside >
formulas.db are only used at the time when you Add, ShowCart, or Purchase. >And only specific named formulas are used. > >There's nothing stopping you from wrapping
[interpret] around a
[lookup] >into the
formulas.db, but that's no different than putting equations >anywhere else -- there is no advantage to putting them inside
formulas.db >except as a way of collecting them all in one place for easier reference. > >Technical Support | ==== eCommerce and Beyond ==== >Pacific Coast Software | WebCatalog, WebMerchant, >11770 Bernardo Plaza Court | SiteEdit Pro, PhotoMaster, >San Diego, CA 92128 | Typhoon >619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com/
Tim Taylor
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:
return missing item (was:WebCat Sales) (1997)
and passing to a cart (1997)
Cart Question (1998)
Configuring E-mail (1997)
Need relative path explanation (1997)
Restricting to one folder hierarchy on the entire server ... (2005)
from outside to inside store direct frame template link? (2000)
Showif, Hideif reverse logic ? (1997)
[INCLUDE] Limitations (1998)
Search in 2 or more catalogs (1997)
Urgent help needed (1998)
Sorting (1998)
webcat- multiple selection in input field (1997)
Can't find templaes (1997)
WebCat2b15MacPlugin - [protect] (1997)
Nested tags count question (1997)
Online reference (1997)
[delete] problem (1997)
multiple credit card merchant accounts/processors (1997)
Associative lookup style? + bit more (1997)