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!

I wouldn't worry much about coloring - use plain CODE tags and it'll be just fine. Whoever needs it will understand.

Is this not possible to fix?

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

Well there's black as well as grey.

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:

SELECT field1, field2
FROM table1, #table2, table3
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:

drop procedure [dbo].[GetImageInfo_P]

Ok that can be fixed.