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