How to make Sublime Text color #foo# not as a comment in SQL query

coldfusion, sublimetext, sublimetext2

Solution

This code formatting is brought to you by the SQL package, not the ColdFusion package.

You can get rid of the comment like formatting by editing the

`Data -> Packages -> SQL -> SQL.tmLanguage` file.

Find `comment.line.number-sign.sql` and replace the regex string `(#)` with `(--)` or something similar.

Problem

I currently use Sublime Text 2 for my ColdFusion coding. When writing this ``` <cfquery name="tester" datasource="#ds#"> SELECT #createODBCDatetime(trim(arguments.foo))# FROM dual; </cfquery> ``` the `#createODBCDatetime(trim(arguments.foo))#` is colored the same as a comment. How do I tell Sublime Text 2 to not treat ## as a comment?

Original source