2 Replies Latest reply on May 31, 2017 12:17 PM by thatJeffSmith-Oracle

    Save HTML Code

    9ad2070a-2c53-4b32-9f19-a5d64f4855c8

      Hello everyone,

       

      I'm working with Oracle Database. So I try to save the html code into the database. Such as: <html> <h1> Hello </h1> </html>. and The data in the database displayed unnormal.
      You can see that in the  picture

       

       

      1.jpg

       

      But When I show it to the View. I still a html code

      2.jpg

       

      My question is: Is that ok to continue to save the html code into my database?

        • 1. Re: Save HTML Code
          Gaz in Oz

          Looks "normal" to me. Screenshot 1, the html has been correctly interpreted and is showing "Hello World" using the <h1> tag definitions. As you show in screenshot 2, what is saved in the database is the text string "<h1>Hello World</h1>"

           

          So I would say all is good.

          • 2. Re: Save HTML Code
            thatJeffSmith-Oracle

            Yeah, what you're seeing in the Grid is our support to actually RENDER the html as long as it's basic stuff, HTML3 stuff.

             

            SELECT '<HTML><li>My Data</li></html>' MoreFunStuff FROM dual

            UNION

            SELECT '<HTML><img src="http://www.wvu.edu/images/wvu.png" height=23 width=134></HTML>' MoreFunStuff FROM dual

            UNION

            SELECT '<HTML><table cols="3" border=2><th>Tables</th><th>Inside of</th><th>Tables</th></table></HTML>' MoreFunStuff FROM dual;

             

            gives you

             

            html_in_grids2.png

             

            If you run you worksheet query using F5, it will you you the 'raw' data as it's stored.