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:
[WebDNA] WebDNA vs. PHP code examples (2008)
Late on Friday.... brain fried (2002)
[WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012)
reserved characters for field names? (1998)
Locking up with WebCatalog... (1997)
WebCatalog and WebMerchant reviewed by InfoWorld (1997)
Anyone trying the Dreamweaver Extensions? (2000)
Banners and sort of random display (1997)
[spawn] and [formvariables] (1999)
RE: Automatic Forwarding using WebCat (1997)
Erotic Sites (1997)
WebCatalog f2 Installation (1997)
Emailer [cart] file names (1997)
Tracking inbound links for discounts (1997)
Summing fields (1997)
User Defined Sorting (1997)
New WebDNA Forum Solution (in development) (2003)
WebMerchant Problem (1999)
Hiding HTML and page breaks (1997)
ShowIf inside formulas (1997)