1 Reply Latest reply on Dec 15, 2008 8:18 AM by comment_1

    Filemaker 9 and XML Exporting.

    javbupe

      Title

      Filemaker 9 and XML Exporting.

      Post

      Hello Everyone, I hope someone can help with this.

       

      I have this small database that im ussing to feed a web site content by exporting the records using FMPDSORESULT. So far i was able to read and user the xml information on this web site. My problem is, when using html tag in one of the field to export (like <p> or <a href ) i getting all this html tags parse by the xml parse and then they ar useless on the web site. I try using <![CDATA[ ... ]]> on the field that i need this content parse as it, but the result is the same, it change every < and > to gt; and lt;

       

      Im not so good doing the xls stylesheet and I dont know if the answer is there.

       

      Thanks fo any help.

       

      The xml file that is been exported right now look like this below, (pay attention into the xml description child):

       

      <?xml version="1.0" encoding="UTF-8" ?>
      <!-- This grammar has been deprecated - use FMPXMLRESULT instead -->
      <FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult">
      <ERRORCODE>0</ERRORCODE>
      <DATABASE>BAFDB.fp7</DATABASE>
      <LAYOUT></LAYOUT>
      <ROW MODID="22" RECORDID="16">
      <kp_media>MEDIA0000000016</kp_media>
      <Title>Fresh News from:</Title>
      <Artist>this artist</Artist>
      <Album></Album>
      <Art_Path>None Type on Calculation</Art_Path>
      <File_Path>None Type on Calculation</File_Path>
      <Description>&lt;![CDATA[&lt;p&gt;this paragraph test&lt;/p&gt;

      &lt;p&gt;this second paragraph&lt;/p&gt;

      Click here: &lt;a href=&quot;http://www.clickhere.html">click here&lt;/a&gt;  to read this article .]]&gt;
      </Description>
      <MediaType>News</MediaType>
      </ROW>
      </FMPDSORESULT>