[TxMt] Joomla/Mambo and latest Textmate

[Jeremy Wilkins]

Hi,

The latest Textmate helpfully highlights SQL in comments, this is  
great apart from with Joomla/Mambo code which actually uses a hash in  
the table name (this gets replaced before it gets as far as mysql) -  
this hash is recognised as a comment, so the end of the string is  
ignored and the rest of your file is treated as a comment.

The tables names are referred to as #__mytable. I'm sure if this  
isn't the best solution but a quick fix is to open

/Applications/Textmate.app/Contents/SharedSupport/Bundles/ 
SQL.tmbundle/Syntaxes/SQL.plist

in Property Editor and navigate to

	/Root/repository/comments/patterns/1/match

and change the regex from

	(#)?.*$\n?

to

	(#)[^_][^_]?.*$\n?

Any better solutions gratefully accepted.

Thanks

jeb