removing RTE tags

Post Reply
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

removing RTE tags

Post by gaurav.shetti »

I am trying to fetch data which contains Rich text editor tags and is of the long field type.
eg
<select A from table where field=$id>
i am querying this to a table on the oracle side.
The result is i am getting the data for A which contains Rich text editor tags . Also the data i am fetching from the oracle is of the long field type. Now i want those RTE tags removed. How can i do it?
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

removing RTE tags

Post by John »

I'm not quite sure I understand where you are selecting the data from (Texis or Oracle), and how you are communicating with Oracle.

If you are selecting from Texis you may be able to do:

select totext(A) from table where field = $id
John Turnbull
Thunderstone Software
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

removing RTE tags

Post by gaurav.shetti »

I am selecting the data from oracle
gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

removing RTE tags

Post by gaurav.shetti »

currently i am getting results like <P><font face= .....
so on
User avatar
mark
Site Admin
Posts: 5513
Joined: Tue Apr 25, 2000 6:56 pm

removing RTE tags

Post by mark »

gaurav.shetti
Posts: 119
Joined: Fri Feb 27, 2009 9:09 am

removing RTE tags

Post by gaurav.shetti »

if suppose i am getting the results from oracle and storing in in a variable say $vars1

then can i use
<fetch "" $vars1>
<urlinfo text>
<$vars1 = $ret>

is that what you were trying to say. :)
User avatar
John
Site Admin
Posts: 2597
Joined: Mon Apr 24, 2000 3:18 pm
Location: Cleveland, OH
Contact:

removing RTE tags

Post by John »

You still want to include the URL to make sure it is treated as URL. It won't fetch the data from there, but will treated the data in the variable as if it was fetched from that URL.
John Turnbull
Thunderstone Software
Post Reply