Re: Character string converstion

Wolf Kammer wrote:
>
> Look at the functions REPLACE or TRANSLATE. You find them in the
> SQL Language Reference Manual, chapter 3: operators, functions...
>
> Hope this helps, Wolf Kammer
>
> On Mon, 2 Dec 1996, Janus Christensen wrote:
>
> > Hello.
> >
> > I have a problem with a web-enabled database containing company names
> > and addresses. Whenever I try to display a company name containing a
> > '&' from the database in a htp.formSubmit the '&' is displayed as an
> > underscore.
> >
> > To get around this problem I have thought about writing a function that
> > replaces all '&' with the HTML ampersand entity (&). All I need
> > now is some functions to read through a string and stuff like that.
> >
> > However, I have some difficulty finding any reference to such functions
> > in the supplied PL/SQL manuals.
> >
> > If there is anybody out there who has had a similar problem I would be
> > grateful for your help.
> >
> > Regards,
> > Janus Christensen
> > Netkey Communication
> > Denmark
> >
> >

How about the HTP.PS procedure in the OWS Devlopers Toolkit? If it doesn't do it, maybe at least you could cannabalize the code. Received on Sun Dec 08 1996 - 00:00:00 CET