RE: [xsl] Escaped Chars from DB display incorrectly...

Subject: RE: [xsl] Escaped Chars from DB display incorrectly...
From: "Michael Kay" <michael.h.kay@xxxxxxxxxxxx>
Date: Wed, 3 Apr 2002 09:19:57 +0100
You want to fix the problem at source. Find out why the text is getting
double-escaped in the first place.

Michael Kay
Software AG
home: Michael.H.Kay@xxxxxxxxxxxx
work: Michael.Kay@xxxxxxxxxxxxxx

> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of King Wilder
> Sent: 03 April 2002 00:39
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE: [xsl] Escaped Chars from DB display incorrectly...
>
>
> Michael,
>
> I checked and you are right, it is Smith &amp;amp; Company.
>
> Any ideas how I would retrieve this to display correctly?
>
> Thanks,
>
> King Wilder
>
> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of Michael Kay
> Sent: Tuesday, April 02, 2002 1:42 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject: RE: [xsl] Escaped Chars from DB display incorrectly...
>
>
> Somewhere while being turned into XML, the string from the
> database is being
> escaped, which isn't necessary as it's already escaped in the
> database. I
> bet the XML built from the DB is actually Smith &amp;amp; Company
>
> Michael Kay
> Software AG
> home: Michael.H.Kay@xxxxxxxxxxxx
> work: Michael.Kay@xxxxxxxxxxxxxx
>
> > -----Original Message-----
> > From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> > [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx]On Behalf Of
> King Wilder
> > Sent: 02 April 2002 22:11
> > To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> > Subject: [xsl] Escaped Chars from DB display incorrectly...
> >
> >
> > I'm using MSXML 4.0 on Windows 2000 Server.  Escaped
> characters don't
> > display correctly from the database.
> >
> >
> > My SQL Server 7.0 table field:
> >
> > Company
> > ------------
> > Smith &amp; Company
> >
> >
> > I dynamically build an XML string...
> >
> > <account>
> > 	<customer company="Smith &amp; Company" />
> > </account>
> >
> >
> > My XSL displays this in a browser...
> >
> > Smith &amp; Company
> >
> >
> > View Source shows this...
> >
> > Smith &amp;amp; Company
> >
> > Any ideas how I can just display: Smith & Company  ?
> >
> > Thanks,
> >
> > King Wilder
> > -------------
> > Gizmo Beach
> > king@xxxxxxxxxxxxxx
> > www.gizmobeach.com
> > 626 351-4334
> > -------------
> >
> >
> >  XSL-List info and archive:
> http://www.mulberrytech.com/xsl/xsl-list
> >
> >
>
>
>  XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
>
>
>
>  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