Extra white-space after page proccess

[Guest]

I am trying to suppress white-spaces after the page is processed.
Usually it doesn't bother me, but it does bother javascript.

Explanation:
1. I am sending an xmlhttp request to coldfusion to process.
2. Coldfusion runs a stored procedure on an oracle database that returns the results as XML.
3. Coldfusion returns the XML back to the client: <cfoutput>#XmlParse(ajaxXML)#</cfoutput>.
4. The client (Javascript) runs the function that handle the data and returns an error because: " xml declaration not at start of external entity".

I have tried using cfsetting with the attribute: enablecfoutputonly="yes", but still the result is the same.

Any idea or lead in the right direction would be greatly appreciated.

[MikerRoo]

It sound like the javascript wants XML, not a parsed data structure. Don't use XmlParse here.

Use: <cfoutput>#Trim (ajaxXML)#</cfoutput>

You can additionally use CFContent to wipe previous output but it is better not to output anything extra in the first place.

[Guest]

Ive tried that, I am trying everything I can think of, but still did not get the result I am aiming for.
I'm sure there is something I am missing here.

Any idea would be greatly appreciated.

Thanks again.

[MikerRoo]

You are going to have to supply more details.

For starters, post the xml exactly as the stored procedure returns it.

[Guest]

The XML that the DB returns, looks like this:

<?xml version="1.0"?>
<rowset>
<row>
<column_name>value</column_name>
<column_name>value</column_name>
....
</row>
</rowset>

After playing with code for a while now, I believe that the problem is not with the returned XML.
The page that runs the SP is the page that call the SP. What means that the white-spaces are the code that the Coldfusion engine has already processed (although, the condition that checks whether the form variable that Ajax request, exist. Is the first thing on the page). to my understanding, the returned XML should be at the top of the page.

I hope that I was clear enough.
Thank you.

[MikerRoo · Accepted solution]

If that really is the content of ajaxXML, then the code above and cfcontent should fix the problem.

Like so:

<CFCONTENT reset="yes">
<CFOUTPUT>#Trim (ajaxXML)#</CFOUTPUT>
<CFABORT> <!--- Display nothing else. --->

[Guest]

Thank you very much :)
Works great.