Re: Custom formulas.db
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 21846
interpreted = N
texte = >>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.Maybe you're right, but ...A long time ago Grant told me (as I recall) that all the formulas stored in the formulas.db would be interpreted without having to use the [interpret] context.He said the formulas.db was recognized by webcat as a special database, and thus any webdna code stored inside would always be interpreted no matter what -- thereby eliminating the need for an [interpret] context when retrieving webdna code from fields in the formulas.db.The reason I asked him about this was so I could learn for myself whether or not it would make sense for me to use the formulas.db for my own custom formulas, instead of entering those formulas directly into my templates.Of course, I never bothered to use that technique anyways. I decided instead to store my reuseable formulas inside [include] files, mainly because it's a whole lot easier to type [include filename] than it is to type [lookup db=formulas.db&value=formulaname&lookinfield=name&returnfield=formula] every time I want to use a reuseable formula.Besides, since [include] files are cached in RAM anyways, I don't think it takes any more time to grab a formula from an [include] file than does to perform a search or a lookup to get that same formula from a field in the formulas database.Which do you think takes less time, using [include] on a cached file or using [lookup] on the formulas.db?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Associated Messages, from the most recent to the oldest:
>>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.Maybe you're right, but ...A long time ago Grant told me (as I recall) that all the formulas stored in the
formulas.db would be interpreted without having to use the
[interpret] context.He said the
formulas.db was recognized by webcat as a special database, and thus any webdna code stored inside would always be interpreted no matter what -- thereby eliminating the need for an
[interpret] context when retrieving webdna code from fields in the
formulas.db.The reason I asked him about this was so I could learn for myself whether or not it would make sense for me to use the
formulas.db for my own custom formulas, instead of entering those formulas directly into my templates.Of course, I never bothered to use that technique anyways. I decided instead to store my reuseable formulas inside
[include] files, mainly because it's a whole lot easier to type [include filename] than it is to type [lookup db=
formulas.db&value=formulaname&lookinfield=name&returnfield=formula] every time I want to use a reuseable formula.Besides, since
[include] files are cached in RAM anyways, I don't think it takes any more time to grab a formula from an
[include] file than does to perform a search or a lookup to get that same formula from a field in the formulas database.Which do you think takes less time, using
[include] on a cached file or using
[lookup] on the
formulas.db?Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net
Kenneth Grome
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:
Searchable list archive (1997)
Problem with shownext (2003)
Email (1998)
Searching for a search solution (2000)
[off] Promotions/ECRC (1997)
[WebDNA] [announce] CICADA Gold Products (2009)
[SHOWIF] (1997)
WebCatalog Affiliates Program Announced -- Share the revenue for promoting WebCatalog (2000)
A question on sub-categories (1997)
Subtotal Not Calculated on Invoice.html (1998)
Associative lookup style? + bit more (1997)
2.1 Stuff (1998)
[WebDNA] Hosting Solution (2013)
Extended [ConvertChars] (1997)
[format] (1998)
[showif],[refferer],[include] in errormessages.db (2002)
about this server and links to who (1997)
Getting total number of items ordered (1997)
problem: mail changed (1997)
WebCat2: multiple currency support (1997)