It may be faster for YOU, but I doubt it'll be faster for your users. You're pulling a bit of text, and then you have to parse it looking for words to replace and then evaluate the result.. I think it would be faster to have the pages.. a .cfm for each statement and just query the DB for the 2 variables you need and output..
On Wed, Feb 27, 2008 at 11:41 AM, Rob Parkhill <[EMAIL PROTECTED]> wrote: > Your assumption is correct. I need to have a variety of statements that are > predefined that I only need to populate a few items in, I am sure that I > could go through all the work of making case statements, or includes, but I > thought that it would be faster/easier to place them into the database. This > way they are a little more manageable. I have a number of calculations that > are occuring on the page to a) choose the correct statements and then b) > populate the values. > > Thanks for your insight. > > Rob > > > >My assumption is he wishes to create a number of predefined template > >statements which can be retrieved from the database as necessary and > >have their missing pieces filled in for display purposes. That's just > >my guess though. > > > >Yes, he could have used include files for each statement, but perhaps he > >wants them to be managed through an interface... > > > >~Brad > > > > >Why are you storing the whole statement? Why not just the variables? > >Maybe I'm missing something, but I would just store the variables in > >the database.. not the whole statement. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299976 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4