Assuming you want CF tags and things in there, there's only one way to do it: write it to a physical file. What we do is write that file every time the data is edited, as well as write a copy to the database table.
-----Original Message----- From: Michael J. Sammut [mailto:[EMAIL PROTECTED] Sent: Friday, 21 March 2003 1:01 p.m. 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
