Thunderstone Support Forums

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?

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

I am selecting the data from oracle

currently i am getting results like <P><font face= .....
so on

In vortex you could
<fetch "http://localhost/index.html" $rtedata>
<urlinfo text>
<$text=$ret>

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.

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.