• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 900
  • Last Modified:

XML Parsing Error: undefined entity

Hello Experts,

Is there a way to solv the following problem, I am reading data from my database to a recordset and converting the recordsert to XML, using the folowing technique;-


However, I am getting the following error:-

XML Parsing Error: undefined entity
Location: http://www.kombat.no/byz_kelkoofeed.asp
Line Number 36, Column 39:<LI><SPAN style="COLOR: #696969">GrĂ½nn&nbsp;-&nbsp;Treetop.</SPAN>

The error is caused by the &nbsp;..

Is there anyway that I can work around this error, i'm fairly new to xml..
Thank you
  • 2
1 Solution
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
&nbsp is a Space, I believe ... you can use the Replace function to convert every instance of &nbsp to space:

Replace("YourStringIn", "&nbsp", " ")

claracruzAuthor Commented:
Thank a mil, should have thought of that...

One more thing if you can help me with it, the database contains letters of the norwegian alphabet, whih sometimes have peculiar charaters, unfortunately this characters are showing up as questions marks, any ideas pls?
claracruzAuthor Commented:
this did it

<%@ CodePage=65001 Language="VBScript"%>

Response.CodePage = 65001
Response.CharSet = "utf-8"

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now