Not sure who maintains the sql syntax bundle, and I would do it myself if I had time right now, but the syntax highlighting breaks if a comment that begins with '--' has a forward slash somewhere after that on the same line. Very nice bundle otherwise.
-- Best regards, Lang Riley
On Apr 5, 2005 1:45 AM, Allan Odgaard allan@macromates.com wrote:
Here is an example that breaks even if I only have a / inside the SQL:
SELECT a.payout_model, a.name, hits, signups, rm_signups, (b.signups - b.rm_signups) AS pm_signups, b.activations, b.has_deposited AS depositing_players, (b.has_deposited / b.hits) AS conversion_rate
Everything after / b.hits get highlighted yellow until the next /
/Joakim Bodin
On Apr 5, 2005, at 8:38, Joakim Bodin wrote:
Ah... seems to be the same problem as with the Ruby syntax. There's a rule that matches /regular expressions/ -- I can change it so that it needs at least another slash at the same line for it to go into regex-coloring mode. Not perfect, but better :)
As for the slash in a comment, I still don't see this happening though.
This is the line that borked syntax highlighting (TransactSQL):
ELSE IF (@Quarter = @WINTER) -- The user has selected a mealplan for Winter/Spring
For now I am just replacing the forward slash with a comma even though it is not my preference. Thanks for looking into it Allan.
TM rocks and especially your agile response to our requests!
On Apr 5, 2005, at 7:34 AM, Allan Odgaard wrote:
-- Best regards, Lang Riley
-
Allan Odgaard -
Joakim Bodin -
Lang Riley