Simple HTML markup to pass thru

[Dryvlyne]

I'm looking for a simple way of adding HTML tags like

<b>sample data</b>

and

sentence1
<br>
sentence2

within my tables so that when I pull out that data onto a web page it displays accordingly.

Thanks

 

[feherke]

Hi

What do you want exactly ?

[blue]SQL>[/blue] create table notmytable ( id number, html varchar2(1000) );

Table created.

[blue]SQL>[/blue] insert into notmytable values ( 1, '<b>sample data</b>' );

1 row created.

[blue]SQL>[/blue] insert into notmytable values ( 2, 'sentence1'||chr(13)||chr(10)||'<br>'||chr(13)||chr(10)||'sentence2' );

1 row created.

[blue]SQL>[/blue] select * from notmytable;

        ID HTML
---------- -------------------------------------------------
         1 <b>sample data</b>
         2 sentence1
           <br>
           sentence2

Feherke.

http://rootshell.be/~feherke/

 

[Beilstwh]

An even easier way is to issue the "set markup" command in sql*plus before running your select. For documentation on using it, see.

Search for the work markup at the following link.

http://download-east.oracle.com/docs/cd/B10501_01/server.920/a90842/ch8.htm#1005745

Bill
Oracle DBA/Developer
New York State, USA

 

[Dryvlyne]

Feherke,

That's exactly what I want to do and I was able to do that. The only problem is when I pull it out of the database onto a web page the data is not bolded and there are not line breaks where they should be.

Perhaps I posted this in the wrong forum - maybe the problem is on the server side where ColdFusion is being using to pull the data from the Oracle DB?

 

[feherke]

Hi

You are right. From that point forward is not Oracle problem. I would suggest to read the HTML specification too. I feel some confusion in your words...

Feherke.

http://rootshell.be/~feherke/