CFHTTP & CFWDDX

[ITGL72]

I'm looking over an error that has me befuddled. Its been working fine. No one has touched the code because I am the only one with access to it here and I know I don't mess with stuff that is working. (For the most part!<g>)


Heres the error:

Error Diagnostic Information:
XML parsing error: not well-formed (error code 4, line 1, column 1, buffer offset 1)
The error occurred while processing an element with general identifier of (CFWWDX), occupying document position 24:2 to 24.75

Here's our code:

(From a multi homed web server on our public IP subnet there's a template that runs and includes this below:e)

<CFHTTP METHOD=&quot;Post&quot;
URL=&quot;

http://10.192.0.7/directory/template.cfm&quot;

DELIMITER=&quot; &quot;
TEXTQUALIFIER=&quot; &quot;
RESOLVEURL=&quot;Yes&quot;>

<CFHTTPPARAM TYPE=&quot;Formfield&quot;
VALUE=&quot;#FORM.SID#&quot;
Name=&quot;SID&quot;>

</CFHTTP>

<CFWDDX INPUT=&quot;#CFHTTP.FileContent#&quot; OUTPUT=&quot;GetEMail&quot; ACTION=&quot;WDDX2CFML&quot;>
(This above line is line 24:2 to 24.75)

When I hard code the above VALUE to say an ID# I know exists in the DB I see that the email address is returned. (I just copied the above code into a blank page, changed #FORM.SID# to some ID# I know exists and it did return the email address so I know atleast the syntax is correct) SO I am assuming the CFHTTP is working but now what is the issue with the CFWDDX line? Like I said, this all worked for months until now. I also had the DB person check the DB to make sure nothing has changed as far as DB fields, etc.



So this is what I am trying to figure out. Why is this error occuring? I have never seen an error screen that had XML info on it. We dont use XML with anything in this app unless its just something thats part of CF Server (We are running CF4 IIS4 NT4 SP6)


Any suggestions?

 

[ITGL72]

Just something to add, I got this piece of news from another board:

&quot;Hi itgl72,
I ran into the same error some time back. After a lot of debugging, I was able to narrow it down to certain recordsets that were causing the errors. I then hardcoded the WDDX packet and started editing it little by little to narrow down the errors. Anyway, what I found was that the error was being caused by certain characters being passed in the packet. I don't remember the exact characters but if I remember correctly it was an ampersand followed by a space. I think I also got the same error with the degrees character. Try to look into your db to see if there are characters that you think could potentially be causing the errors, edit them out and see if the error still persists.&quot;

Well the field it is pulling data out from is used just for EMAIL ADDRESSES, so whatever it brings back will be something like 'me@domain.com'

Maybe something is up with the ID Field it is sending.

What I dont understand is WHY is it doing it now, ahh the life of an IT'r

 

[mad01]

I'm not sure about this...but check if the size you're using for that field is large enough to hold it's values...I'm suggesting this cause you said this code was working fine before... mad01

 

[ITGL72]

Checked the DB, that email column allows up to 50 so I dont think thats it.

I have been told now that it only errors out with SOME email addresses, and sometimes it works fine. Thanks for that piece of info you missed to tell me, LOL - darn users, gotta love them...