PDA

View Full Version : MySQL syntax coloring in Dreamweaver CS3?



Mitthrawnuruodo
Aug 4, 2007, 05:05 PM
As the title says: Is there a way to get syntax colouring for (My)SQL (and possibly other non-default languages) in Dreamweaver CS3?


CANEHDN
Aug 4, 2007, 05:57 PM
What language are you writing the SQL in? I use php and you can't change the specific SQL syntax since the SQL syntax is contained in quotes as a string. It's always the same color as all strings.
Mitthrawnuruodo
Aug 4, 2007, 06:06 PM
Just directly in .sql (and .mysql) text files.

I use them in phpMyAdmin to build the structure in my databases... never really liked that "build the database and tables on first run" in php. That's just creepy... ;)
yagran
Aug 4, 2007, 07:11 PM
As the title says: Is there a way to get syntax colouring for (My)SQL (and possibly other non-default languages) in Dreamweaver CS3?

term, not that i know of.

Bu for sql coding in general, my favourite program (which i rely on heavinly) is http://www.razorsql.com/

http://www.razorsql.com/images/razorsql/mac/4x/mac_main.png

Its really good and cheap too at $50!
Mitthrawnuruodo
Aug 5, 2007, 04:49 AM
Bu for sql coding in general, my favourite program (which i rely on heavinly) is http://www.razorsql.com/
Thanks, I'll look into that... it seems that also features database navigation and administration, which I've also been on the lookout for... :)
elppa
Aug 5, 2007, 05:52 AM
It seems that also features database navigation and administration, which I've also been on the lookout for... :)


You may have already tried it, but there is the free CocoaMySQL (http://cocoamysql.sourceforge.net/). From the screen-shots it is not as advanced as razor SQL and it just deals with MySQL, no other databases. It is also not updated that regularly, but I have found it perfectly adequate for my use.
c3str
Aug 5, 2007, 11:14 AM
I'm surprised that's not an option in preferences/code coloring. Seems like it would be a reasonable expectation.

Found an article on extensible code coloring in MX2004, but nothing recent.
extensible code coloring tutorial (http://www.tutorialized.com/view/tutorial/Extensible-code-coloring/4020)
WildPalms
Aug 5, 2007, 11:18 AM
term, not that i know of.

Bu for sql coding in general, my favourite program (which i rely on heavinly) is http://www.razorsql.com/

http://www.razorsql.com/images/razorsql/mac/4x/mac_main.png

Its really good and cheap too at $50!

Better than Navicat?
SC68Cal
Aug 6, 2007, 04:00 AM
I never found SQL statements to be complex enough to require coloring.
elppa
Aug 6, 2007, 02:14 PM
I never found SQL statements to be complex enough to require coloring.

How come you have two big books (http://www.seanmcollins.com/site/The%20Bookshelf.html) on SQL then ;)

I think it can be beneficial for picking up mistakes quickly.
SC68Cal
Aug 6, 2007, 03:52 PM
How come you have two big books (http://www.seanmcollins.com/site/The%20Bookshelf.html) on SQL then ;)


Uh, because there is more to SQL than just syntax maybe? Perhaps something called database design?

I'll go grab my highlighter :D