Browser can't read output...

[mike777]

<?xml version = &quot;1.0&quot; encoding=&quot;Windows-1252&quot; standalone=&quot;yes&quot;?>
<VFPData>
<xsd:schema id=&quot;VFPData&quot; xmlns:xsd=&quot;

http://www.w3.org/2001/XMLSchema&quot;;

xmlns:msdata=&quot;urn:schemas-microsoft-com:xml-msdata&quot;>
<xsd:element name=&quot;VFPData&quot; msdata:lsDataSet=&quot;true&quot;>
<xsd:complexType>
<xsd:choice maxOccurs=&quot;unbounded&quot;>
<xsd:element name=&quot;tmploan&quot;>
<xsd:complexType>
<xsd:sequence>
<xsd:element name=&quot;loanamt&quot; type=&quot;xsd:double&quot; minOccurs=&quot;0&quot;/>
<xsd:element name=&quot;loanpct&quot; type=&quot;xsd:double&quot; minOccurs=&quot;0&quot;/>
<xsd:element name=&quot;loanterm&quot; type=&quot;xsd:double&quot; minOccurs=&quot;0&quot;/>
<xsd:element name=&quot;appvalue&quot; type=&quot;xsd:double&quot; minOccurs=&quot;0&quot;/>
<xsd:element name=&quot;newvano&quot; minOccurs=&quot;0&quot;>
<xsd:simpleType>

We have a legacy application that outputs XML (we believe). This program was created by a person that no longer works here. We are under the impression that XML output should be able to be read by the browser, but when we open this file (portion prepended above), it shows up exactly as it is above (as opposed to what we expect: a table of data or at least something human-readable).
1) Are we confused??
2) Any suggestions??
Thanking you in advance.
-Mike

 

[culshaja]

What you are posting above is an XSchema which defines the structure of the XML document. An XML document can be told that it should adhere to this schema and an error will be raised in the XML parser if it does not. This is like a type definition for XML. It actually looks like an XDR which is a Microsoft mini-Schema that is used by BizTalk and SQL2000 amongst other things. These use it extensively for checking data validity.

James ;-) James Culshaw
james@miniaturereview.co.uk

http://www.miniaturereview.co.uk

http://www.caninerescue.co.uk

 

[bobcha]

I think it is an XML document which is the result of the CURSORTOXML() function in Visual FoxPro. It contains an XML Schema (in the xsd:schema element), and probably contains the data below this (ie after the xsd:schema element).

The schema is not really useful to you - as James mentioned it is used for validation. By default, the browser will just display the contents of the XML in a tree-like structure. If you want a more reader-friendly format to be dsiplayed in the browser, you need to produce an XSL/XSLT stylesheet. XSL/XSLT stylesheets is (basically) a language for transforming XML into another form - say a HTML table.