RE: [xsl] WHITESPACE WITHIN TAGS.

Subject: RE: [xsl] WHITESPACE WITHIN TAGS.
From: "Michael Kay" <mhk@xxxxxxxxx>
Date: Thu, 4 Sep 2003 11:53:15 +0100
Clearly this problem is in the process that generates your XML and has
absolutely nothing to do with XSLT.

Michael Kay

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of 
> michel geadah
> Sent: 04 September 2003 09:05
> To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx
> Subject: [xsl] WHITESPACE WITHIN TAGS.
> 
> 
> hello,
> I am using oracle 8.1.7 database on windows2000 advanced 
> server and XSU package. When i generate an xml file from the 
> database tables, i get an error message on the internet 
> explorer: "A name contained an invalid character. Error 
> Processing Resource". The problem is that some of the tags 
> are cut into two and the second goes to a new line when the 
> xml file is generated. If i open the file in notepad and 
> readjust the tags to become one on the same line then the xml 
> file is loaded correctly... This is the output of the 
> generated XML on IE6.0.
> 
> 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.
> 
> --------------------------------------------------------------
> -------------
> 
> Whitespace is not allowed at this location. Error processing 
> resource 'file:///Z:/ora81/bin/EMPS.xml'. Line 36, Position 8
> 
> 
> <
> 
> 
> when I open the file in Notepad to view the source i get this 
> See fragments in records 4 & 8)
> 
> <?xml version = '1.0'?>
> <EMPS>
> <mappings Record="1">
> <EMPNO>1000</EMPNO>
> <ENAME>KING</ENAME>
> <JOB>salesman</JOB>
> <MGR>1001</MGR>
> <SAL>2001</SAL>
> <DEPTNO>10</DEPTNO>
> <DOUBLE_SAL>3500</DOUBLE_SAL>
> <PICTURE>333.tif</PICTURE>
> </mappings>
> <mappings Record="2">
> <EMPNO>1001</EMPNO>
> <ENAME>CHARBEL</ENAME>
> <JOB>manager</JOB>
> <SAL>5000</SAL>
> <DEPTNO>10</DEPTNO>
> <DOUBLE_SAL>7000</DOUBLE_SAL>
> <PICTURE>ccc.jpg</PICTURE>
> </mappings>
> <mappings Record="3">
> <EMPNO>1002</EMPNO>
> <ENAME>GEORGES</ENAME>
> <JOB>salesman</JOB>
> <MGR>1001</MGR>
> <SAL>2500</SAL>
> <DEPTNO>11</DEPTNO>
> <DOUBLE_SAL>4000</DOUBLE_SAL>
> <PICTURE>image8.tif</PICTURE>
> </mappings>
> <mappings Record="4">
> <EMPNO>1003</EMPNO>
> <ENAME>MICHEL</ENAME>
> <JOB>manager</JOB>
> <
> SAL>3500</SAL>
> <DEPTNO>12</DEPTNO>
> <DOUBLE_SAL>5000</DOUBLE_SAL>
> <PICTURE>111.TIF</PICTURE>
> </mappings>
> <mappings Record="5">
> <EMPNO>1004</EMPNO>
> <ENAME>JEAN</ENAME>
> <JOB>security</JOB>
> <MGR>1003</MGR>
> <SAL>1750</SAL>
> <DEPTNO>13</DEPTNO>
> <DOUBLE_SAL>4000</DOUBLE_SAL>
> <PICTURE>bmw.jpg</PICTURE>
> </mappings>
> <mappings Record="6">
> <EMPNO>1005</EMPNO>
> <ENAME>RUDI</ENAME>
> <JOB>secretary</JOB>
> <MGR>1003</MGR>
> <SAL>2750</SAL>
> <DEPTNO>13</DEPTNO>
> <DOUBLE_SAL>4000</DOUBLE_SAL>
> <PICTURE>image3.tif</PICTURE>
> </mappings>
> <mappings Record="7">
> <EMPNO>1020</EMPNO>
> <ENAME>GERARD</ENAME>
> <JOB>salesman</JOB>
> <SAL>3200</SAL>
> <DEPTNO>10</DEPTNO>
> <PICTURE>image2.tif</PICTURE>
> </mappings>
> <mappings Reco
> rd="8">
> <EMPNO>2343</EMPNO>
> <ENAME>enhyg</ENAME>
> <SAL>1111</SAL>
> <DEPTNO>13</DEPTNO>
> <PICTURE>image1.tif</PICTURE>
> </mappings>
> <mappings Record="9">
> <EMPNO>1022</EMPNO>
> <ENAME>zico</ENAME>
> <JOB>salesman</JOB>
> <MGR>1000</MGR>
> <HIREDATE>1/21/2001 0:0:0</HIREDATE>
> <SAL>3200</SAL>
> <COMM>1223</COMM>
> <DEPTNO>13</DEPTNO>
> <PICTURE>no_image.tif</PICTURE>
> </mappings>
> <mappings Record="10">
> <EMPNO>1009</EMPNO>
> <ENAME>CHICH</ENAME>
> <SAL>4500</SAL>
> <DEPTNO>13</DEPTNO>
> <PICTURE>image.tif</PICTURE>
> </mappings>
> <mappings Record="11">
> <EMPNO>4532</EMPNO>
> <ENAME>FEFFR</ENAME>
> <JOB>RRR</JOB>
> <MGR>43</MGR>
> <SAL>3535</SAL>
> <COMM>14</COMM>
> <DEPTNO>14</DEPTNO>
> </mappings>
> </EMPS>
> 
> when i fix the fragments in records 4 and 8 and refresh the 
> page the output is displayed correctly... Besides i am using 
> XML SQL utility (XSU) to generate an XML document from inside 
> of the Oracle environment... Does anyone know the solution? 
> Thanks for your help...
> 
> _________________________________________________________________
> MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. 
> http://join.msn.com/?page=features/virus
> 
> 
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
> 


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Current Thread