Hi, interestingly it kinda of works, at least IE display the xml now.
Originally, i replaced all of the > with ">" etc in the query thinking that thwy would be a problem... Ill also try the formatter posted http://alexgorbatchev.com/wiki/SyntaxHighlighter >>> On 07/06/2010 at 2:37 pm, in message <4c0c7794.1070...@ampersand.net.au>, >>> "m...@ampersand.net.au" <m...@ampersand.net.au> wrote: How about #replace(query.xml,"<","<","all")# Dodgy I know but does it work? On 7/06/2010 2:29 PM, Scott Thornton wrote: Thanks, however: <cfcontent variable="#query.xml#"> returns: Attribute validation error for tag cfcontent. java.lang.String is not a supported variable type. The variable is expected to contain binary data. Andrew Scott <andr...@andyscott.id.au> ( mailto:andr...@andyscott.id.au ) 07/06/2010 2:22 pm >>> Try using the cfcontent. On Mon, Jun 7, 2010 at 2:18 PM, Scott Thornton <scott.thorn...@hnehealth.nsw.gov.au> wrote: Hi, I was hoping to achieve something rather simple ( I thought), which was to display on a webpage the xml stored from within a database, in hopefully a formatted manner. The XML is stored unformatted within a database text field. When I save the following XML a text document with an .xml extension, Internet explorer formats it and displays it okay, but a simple output of the database field eg: <cfquery>select ....</cfquery><cfoutput>#query.xml#</cfoutput> Internet explorer displays an error, The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Firefox displays it as one long string. Wrapping the cfoutput in <CODE></CODE> doesn't help. Putting the cfoutput with a CFtextarea helps, but then I need to format it ( indent it to make it more readable ) I guess one potential problem is that the xml string contains another XML string ( partData ) <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ns1:transmissionMessage transmissionGmt="20100517153248" transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME" contentsSigned="false" contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1=" http://hic.gov.au/hiconline/protocol/model"; ( http://hic.gov.au/hiconline/protocol/model )> <adaptor minorVersion="28" majorVersion="6.10" vendor="HIC" platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> </adaptor> <logic minorVersion="56" majorVersion="1" vendor="MCA" platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="OlcHospital"> </logic> <originator minorVersion="1" majorVersion="2.610" vendor="NOT SPECIFIED" platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> </originator> <pki minorVersion="0" majorVersion="2.3.3" vendor="HIC" platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="eSignature"> </pki> <content transactionId="WEB11111111222222" sendCount="1" requestId="1" role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" signed="false"> </content> <partData> <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ns1:inHospitalClaimRequest xmlns:ns1=" http://hic.gov.au/hiconline/eclipse/version-1"; ( http://hic.gov.au/hiconline/eclipse/version-1 )> <claim messagePartId="CID"> <claimTypeCde>PU</claimTypeCde> <facilityId>0012790J</facilityId> <fundBrandId>ABC</fundBrandId> <accountReferenceId>A1234567</accountReferenceId> <senderContact> <name>abc 123</name> <phone>0249853321</phone> <email>emailaddr...@hnehealth.nsw.gov.au</email> </senderContact> <contiguousClaimCde>N</contiguousClaimCde> <urgencyCode>9</urgencyCode> <compensationClaimCde>N</compensationClaimCde> <totalHospitalChargeAmount>58800</totalHospitalChargeAmount> <totalChargeAmount>58800</totalChargeAmount> <facilityTypeCode>1</facilityTypeCode> <patient messagePartId="PAT"> <patient gender="2" dateOfBirth="1939-01-16+10:00"> <identity firstName="firstName" lastName="lastName"/> <residentialAddress postcode="2287"/> <medicare memberRefNum="1" memberNum="1234567707"/> <healthFund memberNum="1234567"/> </patient> <medicalRecordId>97654321</medicalRecordId> </patient> <episode messagePartId="EPD"> <admissionDate>2010-05-03+10:00</admissionDate> <admissionTime>09:24:00+10:00</admissionTime> <dischargeDate>2010-05-05+10:00</dischargeDate> <dischargeTime>15:35:00+10:00</dischargeTime> <episodeId>2116524</episodeId> <patientClassificationCode>OT</patientClassificationCode> <episodeTypeCode>10</episodeTypeCode> <accommodationStatusCode>A</accommodationStatusCode> <sameDayCode>2</sameDayCode> <lengthOfStay>3</lengthOfStay> <dischargeTypeCode>09</dischargeTypeCode> <referralSourceCode>4</referralSourceCode> <admissionCategoryCode>1</admissionCategoryCode> </episode> <accommodationSummary messagePartId="ACS"> <fromDate>2010-05-03+10:00</fromDate> <toDate>2010-05-05+10:00</toDate> <numberOfDays>2</numberOfDays> <leaveDays>0</leaveDays> <accommodationDays>2</accommodationDays> <totalChargeAmount>58800</totalChargeAmount> <chargeRaisedCde>C</chargeRaisedCde> <accommodation messagePartId="ACD00001"> <fromDate>2010-05-03+10:00</fromDate> <toDate>2010-05-05+10:00</toDate> <numberOfDays>2</numberOfDays> <chargeAmount>58800</chargeAmount> <chargeRaisedCde>C</chargeRaisedCde> <dayRate>29400</dayRate> <patientClassificationCode>OT</patientClassificationCode> <bedLevelCode>S</bedLevelCode> <bedLevelAddOnInd>false</bedLevelAddOnInd> </accommodation> </accommodationSummary> <principalService messagePartId="PSG00001"> <serviceDate>2010-05-03+10:00</serviceDate> <serviceTime>09:24:00+10:00</serviceTime> <serviceCode typeCode="C">56507</serviceCode> <chargeAmount>0</chargeAmount> <chargeRaisedCde>I</chargeRaisedCde> <theatreBandCode>0</theatreBandCode> <theatreBandTypeCode>N</theatreBandTypeCode> <theatreCategoryCode>S</theatreCategoryCode> <anaestheticTypeCode>N</anaestheticTypeCode> <totalChargeAmount>0</totalChargeAmount> <theatreMinutes>0</theatreMinutes> </principalService> <drgMorbidity messagePartId="DMG"> <principalDiagnosis> <text>C782</text> </principalDiagnosis> <additionalDiagnosis> <text>C80</text> </additionalDiagnosis> <procedures> <text>5650700</text> </procedures> <procedures> <text>9555000</text> </procedures> <procedures> <text>9555003</text> </procedures> <ventilationHours>0</ventilationHours> </drgMorbidity> </claim> </ns1:inHospitalClaimRequest> </partData> </ns1:transmissionMessage> Can anyone offer a simple solution? The website http://aaronkarp.com/prettyXML/ formats the long string okay, which makes me think there might be some kind of webservice available to do this? PS: A software product external to CF creates the XML and stores it in our database. I have no control over this software and can't modify the XML directly... Thanks, -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email tocfaussie+unsubscr...@googlegroups.com<cfaussie%2bunsubscr...@googlegroups.com> ( mailto:cfaussie%2bunsubscr...@googlegroups.com ). For more options, visit this group athttp://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
