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 4, 2005, at 22:53, Lang Riley wrote:
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.
Can you give an example? I can't reproduce this.
On Apr 5, 2005 1:45 AM, Allan Odgaard allan@macromates.com wrote:
On Apr 4, 2005, at 22:53, Lang Riley wrote:
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.
Can you give an example? I can't reproduce this.
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
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:
[...] 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.
Can you give an example? I can't reproduce this.
Here is an example that breaks even if I only have a / inside the SQL:
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:
On Apr 5, 2005, at 8:38, Joakim Bodin wrote:
[...] 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.
Can you give an example? I can't reproduce this.
Here is an example that breaks even if I only have a / inside the SQL:
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.
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
-- Best regards, Lang Riley
On Apr 5, 2005, at 18:29, Lang Riley wrote:
This is the line that borked syntax highlighting (TransactSQL): ELSE IF (@Quarter = @WINTER) -- The user has selected a mealplan for Winter/Spring
Ah, thanks! The problem is that comments are defined to only have white-space to the left of the two dashes. But I take it, that this is not a requirement of SQL then! :)
I have updated the syntax in the repository.
thanks Allan! On Apr 5, 2005, at 11:27 AM, Allan Odgaard wrote:
On Apr 5, 2005, at 18:29, Lang Riley wrote:
This is the line that borked syntax highlighting (TransactSQL): ELSE IF (@Quarter = @WINTER) -- The user has selected a mealplan for Winter/Spring
Ah, thanks! The problem is that comments are defined to only have white-space to the left of the two dashes. But I take it, that this is not a requirement of SQL then! :)
I have updated the syntax in the repository.
For new threads USE THIS: textmate@lists.macromates.com (threading gets destroyed and the universe will collapse if you don't) http://lists.macromates.com/mailman/listinfo/textmate
-- Best regards, Lang Riley