search

zzyengineer / google-code-prettify

Automatically exported from code.google.com/p/google-code-prettify
Apache License 2.0
0 stars 0 forks source link

SQL Highlight does work for upper case #170

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
I am trying to highlight the sql query(SELECT * FROM TABLE1)
But it does not work but when i try (select * from table1) lower case it does 
work
looks like google-code-prettify does not hight the syntax in upper case
can u please confirm

(Please include HTML, not just your source code)
<html>
    <head>
        <link href="prettify.css" type="text/css" rel="stylesheet"/>
        <script type="text/javascript" src="prettify.js"></script>
    </head>
    <body onload="prettyPrint()">

        <pre class="prettyprint lang-sql" id="sql_lang">
            <span class="kwd">select</span> * SELECT
              from user_ind_columns
             where index_name in
                   (select index_name
                      from dba_indexes
                     where table_name in
                           ('brokercommpymthdrtbl', 'brokercommpymtdetailtbl',
                            'brokercommtxndetailstbl', 'brokercommtxndtltemptbl')
                       and owner in ('loboc64pro')
                    minus
                    select index_name
                      from dba_indexes
                     where table_name in
                           ('brokercommpymthdrtbl', 'brokercommpymtdetailtbl',
                            'brokercommtxndetailstbl', 'brokercommtxndtltemptbl')
                       and owner in ('lob64ors'))
             order by index_name, column_position;
        </pre>

        <pre class=prettyprint>
        int x = foo();  /* This is a comment  <span class="nocode">This is not code</span>
          Continuation of comment */
        int y = bar();
</pre>
    </body>
</html>

What is the expected output?  What do you see instead?
upper case sql should also be highlighted 

What version are you using?  On what browser?
Tried in Mozilla 6.0 and IE 8

Please provide any additional information below.

Original issue reported on code.google.com by srkj...@gmail.com on 19 Sep 2011 at 3:54

GoogleCodeExporter commented 9 years ago 
You need to add

   <script type="text/javascript" src="lang-sql.js"></script>

to load the SQL language handler.

Original comment by mikesamuel@gmail.com on 30 Mar 2012 at 6:22

GoogleCodeExporter commented 9 years ago 
[deleted comment]
GoogleCodeExporter commented 9 years ago 
I get the attached when I add lang-sql.js.

What do you see?

Original comment by mikesamuel@gmail.com on 1 Apr 2012 at 3:59

Attachments:

GoogleCodeExporter commented 9 years ago 
Closed for lack of activity

Original comment by mikesamuel@gmail.com on 5 Feb 2013 at 2:54