Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't convert this XML to cursor
Message
From
14/10/2005 17:04:41
Mike Sue-Ping
Cambridge, Ontario, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Can't convert this XML to cursor
Environment versions
Visual FoxPro:
VFP 9
Miscellaneous
Thread ID:
01059325
Message ID:
01059325
Views:
57
Hi,

I'm trying to convert some XML into a VFP cursor(s). XMLAdapter's LoadXML fails with the following:
XMLError: XML Parse Error: Invalid XML declaration.
Line 1, Position 5   <?xml version="1.0" encoding="utf-8" ?>
XMLTOCURSOR() also fails with a similar error. Any ideas what is wrong?
  <?xml version="1.0" encoding="utf-8" ?> 
  <getFileResult xmlns="http://www.Somesite.com/SomeWebService">
  <dataError>false</dataError> 
  <errorString /> 
  <tblFilesID>749</tblFilesID> 
  <openDate>2005-10-13T12:18:23.6330000-07:00</openDate> 
  <closeDate>0001-01-01T00:00:00.0000000-08:00</closeDate> 
  <tblUsersID_Originator>23064</tblUsersID_Originator> 
  <tblTypesID_Status>69</tblTypesID_Status> 
  <tblTypesID_FileType>14</tblTypesID_FileType> 
  <salePrice>0</salePrice> 
  <lastAccessesDate>2005-10-14T09:59:23.9170000-07:00</lastAccessesDate> 
  <listingPrice>0</listingPrice> 
  <CancelDate>0001-01-01T00:00:00.0000000-08:00</CancelDate> 
  <ArchiveDate>0001-01-01T00:00:00.0000000-08:00</ArchiveDate> 
  <Terms>Some text goes here.</Terms> 
  <fileID_old>0</fileID_old> 
  <tblPrePaidPurchasesID>80</tblPrePaidPurchasesID> 
  <RegionType>163</RegionType> 
  <isTest>false</isTest> 
  <fileStatus>Open</fileStatus> 
  <fileType>Sale</fileType> 
  <fileOriginatorName>Somebody</fileOriginatorName> 
  <escrowInfo>
  <dataError>false</dataError> 
  <errorString /> 
  <tblFilesID>749</tblFilesID> 
  <EscrowNumber>ESC12345</EscrowNumber> 
  <EstimatedCloseDate>2005-11-12T00:00:00.0000000-08:00</EstimatedCloseDate> 
  <ContractAcceptanceDate>2005-10-13T00:00:00.0000000-07:00</ContractAcceptanceDate> 
  <EstimatedDaysUntilClose>30</EstimatedDaysUntilClose> 
  </escrowInfo>
  <titleInfo>
  <dataError>false</dataError> 
  <errorString /> 
  <tblFilesID>749</tblFilesID> 
  </titleInfo>
  <addressInfo>
  <dataError>false</dataError> 
  <errorString /> 
  <tblFilesID>749</tblFilesID> 
  <tblAddressesID>22631</tblAddressesID> 
  <streetNumber>450</streetNumber> 
  <streetDirection /> 
  <streetName>Test</streetName> 
  <streetSuffix>St</streetSuffix> 
  <city>City</city> 
  <zip>92749</zip> 
  <tblTypesID_State>22</tblTypesID_State> 
  <unit>102</unit> 
  <county /> 
  <addressLine1>777 Test St</addressLine1> 
  <cityStateZip>City, ST 11111</cityStateZip> 
  </addressInfo>
  </getFileResult>
Mike
Next
Reply
Map
View

Click here to load this message in the networking platform