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(_at_)lists(_dot_)mulberrytech(_dot_)com
[mailto:owner-xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com] On Behalf Of
michel geadah
Sent: 04 September 2003 09:05
To: XSL-List(_at_)lists(_dot_)mulberrytech(_dot_)com
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