Results 1 to 7 of 7

Thread: highlight=sql with # sign's

  1. #1

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    highlight=sql with # sign's

    When doing a HIGHLIGHT=SQL is it possible to stop having it treat a # sign as a comment character.

    It really messes up the post - look at this example:

    http://www.vbforums.com/showpost.php...82&postcount=4

    # signs are always part of temporary table designations...

    Thanks!

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  2. #2

  3. #3

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    Connecticut
    Posts
    18,263

    Re: highlight=sql with # sign's

    Is this not possible to fix?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  4. #4
    PowerPoster JPnyc's Avatar
    Join Date
    Oct 2002
    Location
    Manhattan
    Posts
    3,015

    Re: highlight=sql with # sign's

    I don't think it's treating it as a comment, but it only colors SQL reserved words. Everything else is 1 color.

  5. #5
    I'm about to be a PowerPoster!
    Join Date
    Jan 2005
    Location
    Everywhere
    Posts
    13,647

    Re: highlight=sql with # sign's

    Well there's black as well as grey.

  6. #6
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

    Re: highlight=sql with # sign's

    I disagree, but think the example post wasn't the best to show it - on lines 18/23/25 the "normal" text is shown in black, but for the others (which include the # character) they are grey.

    Here's another example:
    sql Code:
    1. SELECT field1, field2
    2. FROM table1, #table2, table3
    3. FROM table1, table2, #table3

    I just noticed another issue in post #3 of this thread.. the text "drop procedure [dbo].[GetImageInfo_P]" gets shown like this:
    sql Code:
    1. drop procedure [dbo].[GetImageInfo_P]

  7. #7
    PowerPoster JPnyc's Avatar
    Join Date
    Oct 2002
    Location
    Manhattan
    Posts
    3,015

    Re: highlight=sql with # sign's

    Ok that can be fixed.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width