you could use a js syntax highlighter: http://code.google.com/p/syntaxhighlighter/
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";> > <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";> > <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 to > cfaussie+unsubscr...@googlegroups.com<cfaussie%2bunsubscr...@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.
