1 Reply Latest reply on Oct 19, 2007 10:14 AM by JR "Bob" Dobbs-qSBHQ2

    xml file output

    Nick201
      I am outpting result from query using cfsavecontnent and then output using XMLFormat function. When I write into file
      It is displaying line format. I try to put <BR> in my code but it doesn't work . It will put <BR> tag in xml output.

      code
      <cfsavecontent variable="userxml">
      <Name>
      <FName>#Full_Name##status#</FName>
      <ContactNumber>#WORK_PHONE#</ContactNumber>
      <BirthDate>#DOB#</BirthDate>
      <Status>#type#</Status>
      <focus>#Description#<efocus>
      </Name>


      <cfcontent type="text/xml">
      <cfoutput>
      #XmlFormat(userxml)#
      </cfoutput>

      OUTPUT
      ------------------
      <?xml version="1.0"?> <Member> <Name> <FormattedName>ABC</FormattedName> <ContactNumber></ContactNumber> <BirthDate>12/12/2000</BirthDate> <Status>Member</Member> <focus>IT</focus>