HTML in XML call?

Fergus O'Shea · Nov 21, 2003

I have some text that appears in a Database. This text includes
HTML(e.g. <br> tags).

I also have a Webpage that makes an XML call to that database. But
when the text is displayed on the page, the HTML isn't used, just
printed out as normal text.

Is there some way I can change the text in the Database, so that when
it is called in the XML call, that it displays as HTML?

p.s. I'm not in charge of the Webpage so can't do anything fancy
dynamically. I am only in charge of the Text. Please confine any
answers to that area, thanks.

GIMME · Nov 24, 2003

First examine the data in the database.

If the data looks like

<html>
<body>

instead of
<html>
<body>

Then indeed the data stored in the database needs tweaking to
get it to render. In that case you need to either examine how

or else said:
signs.

If the database has
<html>
<body>

Then see if there is a way in your "xmlcall" to fetch the html
as a CDATA element.

Since, as you described, your options are limited. You may have
to load the html into a gigantic javascript variable, do the
substitution in javascript, and then write the html from javascript.

BTW, there isn't a standard SQL function that changes the <
it < and excetra. I'm stretching even thinking of a sql query
that would do it. Anyone ?

Fergus O'Shea · Nov 25, 2003

Thanks for the input.

In the database it is being stored as <br>. It is only when the XML
call is made that the < is changed to < .

We are playing with the idea of having a Replace function is the front
end to change < to <. This option wasn't previously open to me, but
does seem to solve the problem even though it won't be pretty. I'll
still welcome other suggestions.

Thanks again.

GIMME · Nov 26, 2003

In the database it is being stored as <br>. It is only when the XML
call is made that the < is changed to < .

Can the xml call be configured to store the html in a
CDATA element so that it comes over as < instead of < ?

We are playing with the idea of having a Replace function is the front
end to change < to <. This option wasn't previously open to me, but
does seem to solve the problem even though it won't be pretty. I'll
still welcome other suggestions.

Just for laughs and giggles this replace function might work for you
....

function Html2St( st)
{
return String(st).replace('<','<').replace('>','>').replace(' ','
').replace('\\\\','\\');
}

Fergus O'Shea · Nov 26, 2003

Can the xml call be configured to store the html in a
CDATA element so that it comes over as < instead of < ?

Well the XML goes to more than one location, some of which we don't
have any control of, so that could break the systems of those other
locations.

Just for laughs and giggles this replace function might work for you
...

function Html2St( st)
{
return String(st).replace('<','<').replace('>','>').replace(' ','
').replace('\\\\','\\');
}

I'll send it on, Thanks.

Big problem I need to solve with some unix utils	1	Jun 19, 2022
Embed HTML in XML	4	Jun 13, 2007
Need assistance finetuning HTML, CSS, Javascript - sticky header issue	3	Feb 25, 2022
Image upload not working in browser	4	Sep 9, 2022
XSLT, HTML to XML, understanding external Website	0	Jul 15, 2012
XML/XHTML/HTML differences, bugs... and howto	0	Jan 23, 2013
Help with my responsive home page	2	Dec 14, 2022
HTML tags in textarea	4	May 26, 2010

HTML in XML call?

Fergus O'Shea

GIMME

Fergus O'Shea

GIMME

Fergus O'Shea

Ask a Question

Similar Threads

Members online

Forum statistics

Latest Threads