By SQL, do you mean MS SQL Server? If so, forgive me if this seems a bit unnecessary, as the database allows you to return a recordset as XML, and apply a style sheet natively, and transparently...
While doing what you want would be technically possible, it goes counter to the concept of separating your applications into distinct layers. What happens if you need to change a bit of code later on, or a bug is discovered? Bugs in code is one thing, but bugs in the data is another... -- mailto:[EMAIL PROTECTED] Thursday, March 20, 2003, 8:01:19 PM, you wrote: MJS> Hello all, MJS> I am in a quandry. I am currently storing all my data in a SQL database MJS> using XML for each record. Once the data goes in I am coverting it to be MJS> XML safe (i.e., <span class="this">test</span> is saved as <e;span MJS> class="this">e;test<e;/span>e;). MJS> This leads me to my question. I would like to be able to save CF code to MJS> the database and upon retrieval parse the code. So I have two issues that I MJS> am running into issues with: MJS> 1. I am attempting to unformat the info saved in the XML format and convert MJS> it back to readable code. MJS> 2. Parse the cold fusion code from the db to the screen. MJS> Any thoughts on a good way to go about this? MJS> Regards, MJS> 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4