You can't parse CF code in a variable, it has to exist as a file on the server.
That being said, I've heard of various people creating a ramdisk on their server, pulling the CF code from the database, writting it to the ramdisk, and then CFINCLUDEing it into their app. However, that was before CFMX and it's precompilation cycle, so that won't work anymore (unless you like waiting for the java compiler to spin up every request). You could probably write your cf code, compile it, and the write the .class file to the database and extract that and write it to the CF cfclasses directory after computing the appropriate filename and including it that way, although that'd be a messy proposition. Bottom line, I think you're out of luck, at least with CF. I know you can embed SSI commands in your CF code and the web server (if it supports it) will process them in the returned content. You might be able to leverage that to some degree, depending on what you're doing, but no dynamic CF. barneyb > -----Original Message----- > From: Michael J. Sammut [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 20, 2003 5:01 PM > To: CF-Talk > Subject: Retrieving CFMX code from a db > > > Hello all, > > I am in a quandry. I am currently storing all my data in a SQL database > using XML for each record. Once the data goes in I am coverting it to be > XML safe (i.e., <span class="this">test</span> is saved as <e;span > class="this">e;test<e;/span>e;). > > This leads me to my question. I would like to be able to save CF code to > the database and upon retrieval parse the code. So I have two > issues that I > am running into issues with: > > 1. I am attempting to unformat the info saved in the XML format > and convert > it back to readable code. > 2. Parse the cold fusion code from the db to the screen. > > Any thoughts on a good way to go about this? > > Regards, > Michael J. Sammut > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

