I have a field in a LANSA defined file that is a CLOB. When I do an SQL in an SQLRPGLE program to retrieve the data the character '&' returns '&'.
How do I stop this? What causes this? Are there other characters this will happen to?
& returning &
Re: & returning &
Is the CLOB data formatted as HTML, XMLor just plain text ?
Re: & returning &
That's why the ampersand ( & ) is &
That's also why, for example, less than ( < ) and greater than ( > ) characters would be stored as < and >
See https://www.htmlhelp.com/reference/html ... ecial.html for an example of some of the most common characters.
I don't think you can stop this because it's correct HTML.
That's also why, for example, less than ( < ) and greater than ( > ) characters would be stored as < and >
See https://www.htmlhelp.com/reference/html ... ecial.html for an example of some of the most common characters.
I don't think you can stop this because it's correct HTML.
Re: & returning &
To understand why this happens try this incorrect HTML fragment:
<div> I like use a lot of <div> tags in my HTML pages </div>
It needs to be coded as
<div> I like use a lot of <div> tags in my HTML pages </div>
to work.
<div> I like use a lot of <div> tags in my HTML pages </div>
It needs to be coded as
<div> I like use a lot of <div> tags in my HTML pages </div>
to work.