Creating an XML file with special characters

[emozley]

Hi,

I am trying to write something in vbscript that gets the list of applications installed (add/remove programs) and saves it as an XML file.

I then went to use some more vbscript to send that XML to my web service which will save the data in a database (SQL server).

It's all going quite well however special characters are causing me major problems.

I know that I need to use vbscript to replace & with &amp; and < with &lt; but there are loads of other symbols like the trade mark sign ™ that I don't know how to handle.

In my script I have

set f=fs.CreateTextFile("log.xml",true)
f.WriteLine("<?xml version=""1.0"" encoding=""UTF-8""?>")

However when I send it to the webservice it saves special characters as a ?.

Also if I try different encodings if I try to open the XML file in internet it looks fine but still doesn't submit properly to the webservice.

Any ideas?

Thanks very much

Ed

 

[Qik3Coder]

Hate linking offsite, but this looks perfect:

http://www.codeproject.com/KB/vbscript/vbscript-htmlencode.aspx

HTH,
Lodlaiden

If [blue]you have problems[/blue], I want [green]source code[/green] AND [green]error messages[/green], none of this "[red]there was an error[/red]" [black]crap[/black]