I thought I'd share a quick video demonstrating ColdFusion Builder's SQL editor. What's nice is that there are actually two different editors built in - one old school (and available now) and a new shiny one. Enjoy. (And any comments on the format/viewability/etc of the video are welcome.)
Archived Comments
Ray - nice video, thanks. One question ... when you ran the query with the sort, it sorted by case? The lower case first, Z-A, then upper case, Z-A?
Is that the program doing that? Does that have something to do with your DB?
Yes, Derby is case sensitive on sorts.
Thanks Ray, the Jing video works really well for showing your desktop and the size is great on my screen.
This video post definitely makes me want to work with CF9 and CFBuilder, at least on my local machine. I have CF8 and Eclipse installed at the moment.
Any suggestion on where to start if I want to upgrade? And where to find out about how to make the most of it, stuff like access to db's directly in the IDE like you have?
"Any suggestion on where to start if I want to upgrade?"
You mean CF? The installer should recognize and perform an update of your CF8 server.
"And where to find out about how to make the most of it, stuff like access to db's directly in the IDE like you have?"
Not quite sure I get your meaning. Are you asking how to do what I showed? It should... just work... but I think I may be misreading your question.
Thanks for nice video. I usually work with ms-sql and keep open SQL Server management parallel to eclipse, but this will save my time.
Doh. After so much time spent with CFB I didn't know for this feature :)
However, I prefer Database Explorer that ships, afaik, as part of Eclipse Data Tools , over RDS viewer.
Quote about DTP from Eclipse web site:
"(It provide) Assistance in editing SQL through code completion, formatting, and dialect specialization, greatly enhances productivity. Further, the ability to execute or debug commands, both SQL and stored procedures, rounds out the rapid development process that Eclipse supports so well."
Tho, I am not sure is it possible to install in stand-alone CFB, but I am sure it is if you use plug-in version.
I love the code insight/completion in-line in the cfquery tag (without opening either tool mentioned by Ray).
It's pretty powerful what CFB offers by connecting to server and analyzing code as we type.
Quick Question... Is CFBUILDER going to be paid software onces its finally out of beta?
There is no _official_ word on that.