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:
OT: Flash developer needed (2007)
I assume it is a safe bet this does not help (1998)
Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997)
Help name our technology! (1997)
FEW QUESTIONS (1997)
WebDNA Book? (2003)
Multiple Hideif peramiters (2001)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Post arguments problem mac? (1997)
Question about replacing words (1998)
SFTP (2004)
SQLResult chokes on null values? (2006)
itools (2000)
[numfound] in nested [search] (2000)
Include files (1998)
Search design (1997)
[QuantityPrice] Not working in WebCatNT 2.0.1??? (1997)
Wrong? (1999)
Export database record - another idea (2005)
Serving images from databases (1998)