Results 1 to 6 of 6

Thread: Weird characters in SQL code tags

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Weird characters in SQL code tags

    See this post:
    http://www.vbforums.com/showthread.p...60#post3132060

    The first line is:
    CREATE FUNCTION [dbo].[fn_GetNumbers](@Str NVARCHAR(MAX))

    But it shows in the code windows as:
    CREATE FUNCTION & # 9 1 ; dbo].[fn_GetNumbers](@Str NVARCHAR(MAX))
    (Without the spaces)

    It seems to translate correctly when out of the SQL code tags...

  2. #2
    I'm about to be a PowerPoster! mendhak's Avatar
    Join Date
    Feb 2002
    Location
    Ulaan Baator GooGoo: Frog
    Posts
    38,170

    Re: Weird characters in SQL code tags

    Because the square brackets are used to designate special-formatting areas, I would assume that square brackets inside such an area would be translated to their html entity equivalent. There seems to be something in the formatting algo which removes the & from the & # 9 1 ;

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

    Re: Weird characters in SQL code tags

    The same issue (with the C# formatting, but it is the same tool doing the work) was discussed within the last day: here

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

    Re: Weird characters in SQL code tags

    Maybe we need a sticky listing the highlight tool bugs...

  5. #5

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Weird characters in SQL code tags

    I should have searched.... sorry about that...

    The parsing algorithm should look for complete tags, not just the opening bracket... Because SQL usually has the square brackets in the code...

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

    Re: Weird characters in SQL code tags

    It's nothing to do with the parsing. It's just a typo in an array structure in the plugin code which wraps the parse engine.

    As I posted in the thread linked above, when I get free time these issues will all 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