RE: [cfaussie] Display XML on webpage
Scott How about http://aaronkarp.com/prettyXML/"; method="POST"> [^<]*", CFHTTP.FileContent) /> #formattedXML[1]# Steve -Original Message- From: Scott Thornton [mailto:scott.thorn...@hnehealth.nsw.gov.au] Sent: Monday, 7 June 2010 2:54 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Display XML on webpage Hi, I have now. it will also need special formatting to make it more readable. >>> Blair McKenzie 07/06/2010 2:50 pm >>> Have you tried the htmleditformat function? On Mon, Jun 7, 2010 at 2:44 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > 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: > > 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 ( 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: > select #query.xml# > 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 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 ) > > 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 )>majorVersion="6.10" vendor="HIC" > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="OlcHospital"> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="eSignature"> > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false">encoding="UTF-8" standalone="yes"?>xmlns:ns1=" > http://hic.gov.au/hiconline/eclipse/version-1"; ( > http://hic.gov.au/hiconline/eclipse/version-1 )> messagePartId="CID"> PU > 0012790J ABC > A1234567 > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > N > 9 > N > 58800 > 58800 > 1messagePartId="PAT"> dateOfBirth="1939-01-16+10:00">firstName="firstName" lastName="lastName"/> > memberRefNum="1" memberNum="1234567707"/>memberNum="1234567"/> > 97654321 > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 3 > 09 > 4 > 1 > > 2010-05-03+10:00 > 2010-05-05+10:00 2
Re: [cfaussie] Display XML on webpage
cfcontent will need the xml defined in the type attribute. On Mon, Jun 7, 2010 at 2:29 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > > Thanks, however: > > > > returns: > > Attribute validation error for tag cfcontent. > java.lang.String is not a supported variable type. The variable is expected > to contain binary data. > > -- 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.
Re: [cfaussie] Display XML on webpage
Hi, I have now. it will also need special formatting to make it more readable. >>> Blair McKenzie 07/06/2010 2:50 pm >>> Have you tried the htmleditformat function? On Mon, Jun 7, 2010 at 2:44 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > 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: > > 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 ( 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: > select #query.xml# > 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 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 ) > > 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 )>majorVersion="6.10" vendor="HIC" > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="OlcHospital"> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="eSignature"> > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false">encoding="UTF-8" standalone="yes"?>xmlns:ns1=" > http://hic.gov.au/hiconline/eclipse/version-1"; ( > http://hic.gov.au/hiconline/eclipse/version-1 )> messagePartId="CID"> PU > 0012790J ABC > A1234567 > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > N > 9 > N > 58800 > 58800 > 1messagePartId="PAT"> dateOfBirth="1939-01-16+10:00">firstName="firstName" lastName="lastName"/> > memberRefNum="1" memberNum="1234567707"/>memberNum="1234567"/> > 97654321 > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 3 > 09 > 4 > 1 > > 2010-05-03+10:00 > 2010-05-05+10:00 2 > 0 > 2 > 58800 > C messagePartId="ACD1"> > 2010-05-03+10:00 > 2010-05-05+10:00 > 2 > 58800 > C 29400 > OT > S > false > messagePartId="PSG1"> > 2010-05-03+10:00 > 09:24:00+10:00 typeCode="C">56507 0 > I > 0 > N > S > N > 0 > 0 > > C782 >C80 > > 5650700 > 9555000 >9555003 > 0 > > > > 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 gro
Re: [cfaussie] Display XML on webpage
I was thinking also with or blocks as well. On 7/06/2010 2:44 PM, Scott Thornton wrote: 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" 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: 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 ( 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 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: select #query.xml# 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 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 ) " http://hic.gov.au/hiconline/protocol/model" ( http://hic.gov.au/hiconline/protocol/model )> " http://hic.gov.au/hiconline/eclipse/version-1" ( http://hic.gov.au/hiconline/eclipse/version-1 )>PU 0012790J ABC A1234567abc 123 0249853321 emailaddr...@hnehealth.nsw.gov.au N 9 N 58800 58800 1 97654321 2010-05-03+10:00 09:24:00+10:00 2010-05-05+10:00 2116524 OT 10 A 2 3 09 4 1 2010-05-03+10:00 2010-05-05+10:00 2 0 2 58800 C2010-05-03+10:00 2010-05-05+10:00 2 58800 C 29400 OT S false2010-05-03+10:00 09:24:00+10:00 56507 0 I 0 N S N 0 0 C782 C80 5650700 9555000 9555003 0 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 cfaussie@googlegroups.com. To unsubscribe from this group, send email tocfaussie+unsubscr...@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.
Re: [cfaussie] Display XML on webpage
Have you tried the htmleditformat function? On Mon, Jun 7, 2010 at 2:44 PM, Scott Thornton < scott.thorn...@hnehealth.nsw.gov.au> wrote: > 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: > > 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 ( 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: > select #query.xml# > 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 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 ) > > 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 )>majorVersion="6.10" vendor="HIC" > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="OlcHospital"> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > platform="os: > Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="eSignature"> > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false">encoding="UTF-8" standalone="yes"?>xmlns:ns1=" > http://hic.gov.au/hiconline/eclipse/version-1"; ( > http://hic.gov.au/hiconline/eclipse/version-1 )> messagePartId="CID"> PU > 0012790J ABC > A1234567 > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > N > 9 > N > 58800 > 58800 > 1messagePartId="PAT"> dateOfBirth="1939-01-16+10:00">firstName="firstName" lastName="lastName"/> > memberRefNum="1" memberNum="1234567707"/>memberNum="1234567"/> > 97654321 > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 3 > 09 > 4 > 1 > > 2010-05-03+10:00 > 2010-05-05+10:00 2 > 0 > 2 > 58800 > C messagePartId="ACD1"> > 2010-05-03+10:00 > 2010-05-05+10:00 > 2 > 58800 > C 29400 > OT > S > false > messagePartId="PSG1"> > 2010-05-03+10:00 > 09:24:00+10:00 typeCode="C">56507 0 > I > 0 > N > S > N > 0 > 0 > > C782 >C80 > > 5650700 > 9555000 >9555003 > 0 > > > > 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 > > > ( > mailto:cfaussie%2bunsubscr...@googlegroups.com). > For more
Re: [cfaussie] Display XML on webpage
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" 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: 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 ( 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 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: select #query.xml# 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 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 ) http://hic.gov.au/hiconline/protocol/model"; ( http://hic.gov.au/hiconline/protocol/model )> http://hic.gov.au/hiconline/eclipse/version-1"; ( http://hic.gov.au/hiconline/eclipse/version-1 )>PU 0012790J ABC A1234567 abc 123 0249853321 emailaddr...@hnehealth.nsw.gov.au N 9 N 58800 58800 1 97654321 2010-05-03+10:00 09:24:00+10:00 2010-05-05+10:00 15:35:00+10:00 2116524 OT 10 A 2 3 09 4 1 2010-05-03+10:00 2010-05-05+10:00 2 0 2 58800 C2010-05-03+10:00 2010-05-05+10:00 2 58800 C 29400 OT S false 2010-05-03+10:00 09:24:00+10:00 56507 0 I 0 N S N 0 0 C782 C80 5650700 9555000 9555003 0 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 ( 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://gro
Re: [cfaussie] Display XML on webpage
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: 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 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: select #query.xml# 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 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 ) " http://hic.gov.au/hiconline/protocol/model"> " http://hic.gov.au/hiconline/eclipse/version-1"> PU 0012790J ABC A1234567 abc 123 0249853321 emailaddr...@hnehealth.nsw.gov.au N 9 N 58800 58800 1 97654321 2010-05-03+10:00 09:24:00+10:00 2010-05-05+10:00 15:35:00+10:00 2116524 OT 10 A 2 3 09 4 1 2010-05-03+10:00 2010-05-05+10:00 2 0 2 58800 C 2010-05-03+10:00 2010-05-05+10:00 2 58800 C 29400 OT S false 2010-05-03+10:00 09:24:00+10:00 56507 0 I 0 N S N 0 0 C782 C80 5650700 9555000 9555003 0 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 cfaussie@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.
Re: [cfaussie] Display XML on webpage
Thanks, however: 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 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: > > select > #query.xml# > > 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 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 ) > > > transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME" > contentsSigned="false" > contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1=" > http://hic.gov.au/hiconline/protocol/model";> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > > > > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > > > > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false"> > > > >http://hic.gov.au/hiconline/eclipse/version-1";> > >PU >0012790J >ABC >A1234567 > > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > >N >9 >N >58800 >58800 >1 > > > > > > > > 97654321 > > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 > 3 > 09 > 4 > 1 > > > 2010-05-03+10:00 > 2010-05-05+10:00 > 2 > 0 > 2 > 58800 > C > >2010-05-03+10:00 >2010-05-05+10:00 >2 >58800 >C >29400 >OT >S >false > > > > 2010-05-03+10:00 > 09:24:00+10:00 > 56507 > 0 > I > 0 > N > S > N > 0 > 0 > > > >C782 > > >C80 > > >5650700 > > >9555000 > > >9555003 > > 0 > > > > > > > > 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 > . > 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. -- 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,
Re: [cfaussie] Display XML on webpage
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: > > select > #query.xml# > > 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 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 ) > > > transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME" > contentsSigned="false" > contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1=" > http://hic.gov.au/hiconline/protocol/model";> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > > > > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > > > > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false"> > > > >http://hic.gov.au/hiconline/eclipse/version-1";> > >PU >0012790J >ABC >A1234567 > > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > >N >9 >N >58800 >58800 >1 > > > > > > > > 97654321 > > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 > 3 > 09 > 4 > 1 > > > 2010-05-03+10:00 > 2010-05-05+10:00 > 2 > 0 > 2 > 58800 > C > >2010-05-03+10:00 >2010-05-05+10:00 >2 >58800 >C >29400 >OT >S >false > > > > 2010-05-03+10:00 > 09:24:00+10:00 > 56507 > 0 > I > 0 > N > S > N > 0 > 0 > > > >C782 > > >C80 > > >5650700 > > >9555000 > > >9555003 > > 0 > > > > > > > > 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 > . > 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.
Re: [cfaussie] Display XML on webpage
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: > > select > #query.xml# > > 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 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 ) > > > transmissionId="WEB20117091e4bf161a06700" from="WEB20117" mode="FIXME" > contentsSigned="false" > contentsType="MCA/OlcHospital/inhospitalclaimreques...@1" xmlns:ns1=" > http://hic.gov.au/hiconline/protocol/model";> > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="HicOnline"> > > > > platform="os: Windows 2003 x86 5.2 jre: Sun 1.5.0_05" product="Platypus2"> > > > > role="" dataRef="1" type="MCA/OlcHospital/inhospitalclaimreques...@1" > signed="false"> > > > >http://hic.gov.au/hiconline/eclipse/version-1";> > >PU >0012790J >ABC >A1234567 > > abc 123 > 0249853321 > emailaddr...@hnehealth.nsw.gov.au > >N >9 >N >58800 >58800 >1 > > > > > > > > 97654321 > > > 2010-05-03+10:00 > 09:24:00+10:00 > 2010-05-05+10:00 > 15:35:00+10:00 > 2116524 > OT > 10 > A > 2 > 3 > 09 > 4 > 1 > > > 2010-05-03+10:00 > 2010-05-05+10:00 > 2 > 0 > 2 > 58800 > C > >2010-05-03+10:00 >2010-05-05+10:00 >2 >58800 >C >29400 >OT >S >false > > > > 2010-05-03+10:00 > 09:24:00+10:00 > 56507 > 0 > I > 0 > N > S > N > 0 > 0 > > > >C782 > > >C80 > > >5650700 > > >9555000 > > >9555003 > > 0 > > > > > > > > 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 > . > 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.
