I believe the name attribute tell
cfhttp to parse a remote CSV into a query, hence "Invalid Column".
Also, if I remember correctly, you can hand XmlParse() a url so you
don't even need the cfhttp at all.
Mike.
Chris Gomez wrote:
I'm trying to access a xml file from a remote server using
CFHTTP. I'm using CFMX 7.02 developer edition. As soon as the cfhttp
tries to access the file, it generates a invalid column error on the
XML declaration line. I can view the xml file in my browser so I know
that's not at fault.
Here's the code I'm using on a test site:
<cftry>
<cfhttp url="" moz-do-not-send="true"
href="http://www.cleantechworks.com/cleantechworks/newfile.xml">http://www.cleantechworks.com/cleantechworks/newfile.xml
method="get"
result="xml1"
name="Available"
throwOnError="true"
charset="utf-8"></cfhttp>
<cfcatch>
<cfdump var="#cfcatch#">
<cfabort>
</cfcatch>
</cftry>
<cfset x1 = XMLParse(xml1)>
<cfdump var="#x1#">
Any help appreciated.
Thanks,
Chris
--
"Fortune favors the prepared mind."
- Louis Pasteur
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
|
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.instantspot.com/
www.teksystems.com/
