Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL


Viewing HTML and XML data in Interactive SQL

 View HTML and XML data (Interactive SQL)
  1. Connect to the database.

  2. Execute a query that returns a result set that contains HTML and XML data.

    To view a sample result set that contains HTML, run the following query:

    SELECT '<html>
      <meta http-equiv=Content-Type content="text/html; charset=windows-1252">
       <title>Tee Shirt</title>
     <body lang=EN-US>
       <span  style=font-size:10.0pt;font-family:Arial>
       We have improved the design of this perennial favorite. 
       A sleek and technical shirt built for the trail, track, or 
       sidewalk. UPF rating of 50+.

    To view a sample result set that contains a well-formed XML document, run the following query:

    SELECT '<?xml version="1.0" encoding="UTF-8"?>
            <child name="Tim" />
            <child name="Katie" />
  3. In the results, select a cell that contains HTML or XML content, click ..., and then click View in Window.

    The Value of Column column-name window appears.

  4. Click OK to close the window.