Re: Preserve HTML format when inserting into HTML

2010-09-10 Thread Jake Munson
Woot! Found it: http://www.mail-archive.com/cf-talk@houseoffusion.com/msg312892.html I have _never_ seen this in use, but it works perfectly: cfset x.root.child[1].xmlCData = s Awesome! xmlCData? Who knew? And it takes care of the cdata tag for you as well. Very nice. Thanks for

Re: Preserve HTML format when inserting into HTML

2010-09-08 Thread Jake Munson
But like I said earlier, I created a workaround so I'm not stressing about it. It's just odd. I have found the same problem with a different XML file. I am going to try to put together a proof of concept to see if other people besides me can recreate this issue.

Re: Preserve HTML format when inserting into HTML

2010-09-08 Thread Jake Munson
Ok, guys, I have a working proof of concept. At least on my server, this simple 4 line code example illustrates the problem. To recreate, dowload this file: http://techfeed.net/xmlHTMLTest.zip And then follow these steps. 1. Extract the zip to your ColdFusion sites directory. 2. BEFORE

Re: Preserve HTML format when inserting into HTML

2010-09-08 Thread Jake Munson
Ray, In addition to my previous email with proof of concept code, I am able to reproduce my problem using your code below by adding this cffile tag to the end of your code: cffile action=write file=#expandPath('foo.xml')# output=#toString(x)# Weird. I can't reproduce this: cfset s = font

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
As far as I know, CF will not encode HTML unless you tell it to. Are you 100% sure you aren't using htmlEditFormat on the data? I have traced the XML value from start to end, and it appears that the place where the HTML is being converted is when I write the XML to disk. I am dumping the XML

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
As far as I know, CF will not encode HTML unless you tell it to. Are you 100% sure you aren't using htmlEditFormat on the data? I have traced the XML value from start to end, and it appears that the place where the HTML is being converted is when I write the XML to disk. I am dumping the XML

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
As far as I know, CF will not encode HTML unless you tell it to. Are you 100% sure you aren't using htmlEditFormat on the data? I have traced the XML value from start to end, and it appears that the place where the HTML is being converted is when I write the XML to disk. I am dumping the XML

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
When verifying the dumped text throughout the process, you're looking at the view source version, and not the one that's rendered by the browser, right? Sorry for the multiple replies earlier...I have no idea why that happened. Yes, that's correct I'm using view source. In fact, I even

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
When you cfdump something, it escapes it. So if you view source it, you are seeing cfdump's escape. In other words, it isn't the REAL value. I suppose you probably saw my other response (I think we passed each other at the intersection), but if not... If I display the pre-xml value using

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
So wait - you put the string into an XML object? Maybe you can pastebin more of the code. I have developed a workaround that avoids this problem, but for educational purposes here's the bit of code that seems to be hosing the HTML: cfset parksXML.Parks.Park[i].SiteAbstract.XmlText = editCopy

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
Before the above XML insert this HTML is not escaped (as explained in a previous message). After the insert it looks like this: lt;font color=#045172 size=12gt;lt;bgt;Trenner Parklt;/bgt;lt;/fontgt;lt;brgt;lt;brgt; I should reiterate that I am not dumping the XML object and seeing this

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
Normally when you put HTML into an XML node, it has to be within cdata. So maybe CF is fixing the HTML for you? Yeah, I was just simplifying things, I do have a cdata tag wrapping the HTML. Doesn't help. ~| Order the Adobe

Re: Preserve HTML format when inserting into HTML

2010-09-07 Thread Jake Munson
I did something similar in a test page, but using the XML functions instead of cfxml. I was not able to reproduce it either...there's something odd about the original XML that is causing this, I guess. But like I said earlier, I created a workaround so I'm not stressing about it. It's just

Preserve HTML format when inserting into HTML

2010-09-03 Thread Jake Munson
I have an XML object that was populated from an XML file. This XML comes from an external system that I do not control. Here is the bit of XML that I'm struggling with: parks park SiteAbstract ![CDATA[font color=#045172bLoveridge Bridge North/b/font]] /SiteAbstract /park

OT: Open Letter to Tim Buntel

2007-08-23 Thread Jake Munson
I am posting this link here, because I hope that my message spreads enough that someone from Adobe notices. Sorry for the 'spammy' message. http://techfeed.net/blog/index.cfm/2007/8/22/Open-Letter-to-Tim-Buntel ~| Download

Re: Why Framework? Which Framework? And How I can use one?

2006-10-28 Thread Jake Munson
I had an IM chat with Sean Corfield about this, and he said that Model Glue has an extension point to add a custom URL - event object processor so you can hook in SES. As far as Fusebox, it you can use his little .cfm file in your Application.cfm or cfc.Here's a link to a post he made

RE: Inserting a delimited list into a database

2002-02-28 Thread Jake Munson
Oh yeah!!! You are absolutely correct! John, tell Matthew what he's won. ;) -Jake --- Matthew Walker [EMAIL PROTECTED] wrote: Hey ho! The problem is having a table called Update! Try wrapping [] around update. -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED

Inserting a delimited list into a database

2002-02-27 Thread Jake Munson
I have a form that returns a comma delimited list of numbers from some checkboxes that each have the same name. I want to be able to insert a new record in a database for each checkbox that was checked in my form. I figured that if I used a list loop based on my checkbox list, that I could have

RE: Foreign keys

2002-02-21 Thread Jake Munson
date field to something else instead of date. Isn't that a reserved word? Cody ::: -Original Message- ::: From: Jake Munson [mailto:[EMAIL PROTECTED]] ::: Sent: Wednesday, February 20, 2002 8:39 PM ::: To: CF-Talk ::: Subject: RE: Foreign keys ::: ::: ::: Nope, I

RE: Foreign keys

2002-02-20 Thread Jake Munson
#, '#form.comments#') /CFQUERY __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 19, 2002 7:38 PM To: CF-Talk Subject: Foreign keys Hi guys

RE: Foreign keys

2002-02-20 Thread Jake Munson
-Original Message- From: Jake Munson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 21 February 2002 8:53 AM To: CF-Talk Subject: RE: Foreign keys Thanks for the reply. I tried that, and I still got an error with this query: Syntax error in INSERT INTO statement. The error occurred

Foreign keys

2002-02-19 Thread Jake Munson
Hi guys, How can I insert the id field of a query into another table? What I am wanting is to use the id from one table as a foreign key in another table. To do this, I run a query on the two tables, and then I want to insert the primary keys (field named id) from these two tables as foreign