Home of the ColdFusion Community
|
Mailing Lists
|
Home /
Groups /
XML
ColdFusion 8 problem with xmlsearch or malformed xml ?? access 2003 exported xml
Author: Robert Bell
Short Link: http://www.houseoffusion.com/groups/xml/thread.cfm/threadid:105#231
I am having a CF8 problem reading an xml file exported from Access 2003.
My array returned from the xmlsearch function is empty. I dump the xml
doument I get a fully populated structure. If I validate the xml file with
xmlvalidate() I get:
1 [Error] :2:91: cvc-elt.1: Cannot find the declaration of element 'dataroot'.
Here is the code, and example of the xml file. Any ideas would be appreciated.
Thanks, Bob
<body>
<cfset xml = XMLParse("http://aplacmc/dir/some.xml") />
<cfset contacts = XMLSearch(xml,'/Media_x0020_Contacts/id') />
<cfoutput>
<!--- <cfdump var="#xml#"> --->
contacts<br />
<cfdump var="#contacts#">
<!--- xml<br /><cfdump var="#xml#"> --->
arraylen:#ArrayLen(contacts)# <br>
<cfset myResults=XMLValidate(xml)>
Dump of myResults structure returned by XMLValidate<br>
<cfdump var="#myResults#">
<cfloop index="i" from="1" to="#ArrayLen(contacts)#">
Contact: #contacts[i].xmlchildren[1].xmltext#
#contacts[i].xmlchildren[2].xmltext# /><br />
</cfloop>
</cfoutput>
</body>
</html>
======== xml file ===========
<?xml version="1.0" encoding="UTF-8"?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata"
generated="2008-05-20T14:02:27">
<Media_x0020_Contacts>
<ID>163</ID>
<Media_x0020_Name>media name</Media_x0020_Name>
<Zip>0</Zip>
<Fax_x0020_Group>0</Fax_x0020_Group>
<selected>0</selected>
</Media_x0020_Contacts>
<Media_x0020_Contacts>
<ID>1</ID>
<Language>English</Language>
<Media_x0020_Type>Print</Media_x0020_Type>
<Media_x0020_Name>Austin American Statesman</Media_x0020_Name>
<Last>Zipp</Last>
<First>Fred</First>
<Title>Managing Editor</Title>
<E-mail_x0020_address>news@statesman.com</E-mail_x0020_address>
<Work_x0020_phone>512-912-2983</Work_x0020_phone>
<Fax>512-999-999</Fax>
<URL>#http://www.statesman.com/#</URL>;
<Street_x0020_address>305 S. Congress Ave.</Street_x0020_address>
<City>Austin</City>
<ST>TX</ST>
<Zip>78704</Zip>
<Fax_x0020_Group>1</Fax_x0020_Group>
<selected>0</selected>
</Media_x0020_Contacts>
</dataroot>
|
June 20, 2013
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
