Loading ...
Sorry, an error occurred while loading the content.

Another minor syntax highlighting issue...

Expand Messages
  • Rick Owen
    Sorry to keep picking at these little nits, but it is so close that I hate to let it drop until everything looks as perfect as humanly possible. In the SQL
    Message 1 of 2 , Sep 4, 2006
    • 0 Attachment
      Sorry to keep picking at these little nits, but it is so close that I hate to let it drop until everything looks as perfect as humanly possible.

      In the SQL that is between the <cfquery> and </cfquery>, strings are not being highlighted as such.  For example,

                  <cfquery name="q_get_00trn605" datasource="#data#">
                     select to_char(complete_date,'mm/dd/yyyy') as complete_date, complete_date as cdate
                       from class_attend ca inner join class cl on ca.class_code = cl.class_code
                      where emp_ssn_num = '#q_get_newemp_list.emp_ssn_num#'
                        and course_code = '00TRN605'
                        and course_rev_num = '02'
                        and instr_type_code = 'CK'
                        and rownum=1
                      order by complete_date asc
                  </cfquery>

       
      In the above query, the "mm/dd/yyyy", the "#q_get_newemp_list.emp_ssn_num#", the "00TRN605", the "02" and the "CK" should all be highlighted as strings, but they are showing as plain text.

      Attached is a screen shot.

      Rick.

    • Jon Green
      ... Fix: Jon. ... *************** ... ; cfmsql file highlighting 0 hilight .hilight.cfmsql 3 75 $global-scheme + hilight .hilight.cfmsql
      Message 2 of 2 , Sep 5, 2006
      • 0 Attachment
        Rick Owen wrote:
        > Sorry to keep picking at these little nits, but it is so close that I
        > hate to let it drop until everything looks as perfect as humanly possible.
        >
        > In the SQL that is between the <cfquery> and </cfquery>, strings are not
        > being highlighted as such. For example,
        >
        > <cfquery name="q_get_00trn605" datasource="#data#">
        > select to_char(complete_date,'mm/dd/yyyy') as
        > complete_date, complete_date as cdate
        > from class_attend ca inner join class cl on
        > ca.class_code = cl.class_code
        > where emp_ssn_num = '#q_get_newemp_list.emp_ssn_num#'
        > and course_code = '00TRN605'
        > and course_rev_num = '02'
        > and instr_type_code = 'CK'
        > and rownum=1
        > order by complete_date asc
        > </cfquery>
        >
        >
        > In the above query, the "mm/dd/yyyy", the
        > "#q_get_newemp_list.emp_ssn_num#", the "00TRN605", the "02" and the "CK"
        > should all be highlighted as strings, but they are showing as plain text.
        >
        > Attached is a screen shot.
        >
        > Rick.
        >

        Fix:
        Jon.

        *** /home/jon/.jasspa/jon/hkcfms.emf~ 2006-09-04 21:16:45.105747000 +0100
        --- /home/jon/.jasspa/jon/hkcfms.emf 2006-09-05 10:06:00.092479000 +0100
        ***************
        *** 410,415 ****
        --- 410,417 ----

        ; cfmsql file highlighting
        0 hilight .hilight.cfmsql 3 75 $global-scheme
        + hilight .hilight.cfmsql 0x804 "'" "'" "\\" .scheme.string
        + hilight .hilight.cfmsql 0x804 "\"" "\"" "\\" .scheme.string
        hilight .hilight.cfmsql 4 "<!---" "--->" "" .scheme.comment
        hilight .hilight.cfmsql 4 "#" "#" "" .scheme.variable
        ; Jump to the new <cf...> tags scheme
        [EXIT 1]
      Your message has been successfully submitted and would be delivered to recipients shortly.