Database Explorer Updated

Ben Forta sent in some nice updates to the ColdFusion Database Explorer. I've added these to the download. The new features include the ability to hide views (which really helps on SQL Server) and metadata about query results, as seen below:

Click on the image above for a larger version. Query result data is show for all queries now. In cases where data is returned, tabs are used. In the screen shot, you can see a delete example and how it now tells you how many rows were affected, which is pretty cool.

Comments

[Add Comment] [Subscribe to Comments]

Aaron Longnion said on 09-21-2007 at 2:49 PM #
	it's cool, but http://dbx.riaforge.org/ is much more feature-rich (for SQL 2000 and 2005 at least) and supports MX 6.1+ instead of CF 8 only...

Pat Buchanan said on 09-21-2007 at 4:54 PM #
	For those of us that use multiple backends, such as Oracle, SQL Server, Access, etc - this is much nicer than DBX. Just my 2 cents, and but thanks for the info.

Michael Kirby said on 09-25-2007 at 5:38 PM #
	It looks great but when I try to use it on my CF8 installation, I get logged into the Administrator and choose a datasource. It shows the table names on the left but nothing else. I try the page with ?cfdebug and I can see where a info:widget: Firing selection change event for tree id: tabletree is firing but nothing is showing up. No field names, nothing.

Raymond Camden said on 09-26-2007 at 8:13 AM #
	Odd. Feel like digging into the code to see if anything is up? Also - maybe add some cflog - ensure that cfdbinfo is actually finding the column names.

Michael Kirby said on 09-26-2007 at 8:22 AM #
	Absolutely, where would be the best use of cflog?

Raymond Camden said on 09-26-2007 at 8:32 AM #
	Look where I get the cols - and perhaps just log the # of records returned in the query.

Michael Kirby said on 09-26-2007 at 9:08 AM #
	Hate to say it, but you're dealing with a relative nubbie. I put <cflog text="#cols#" file="db-cols"> after the <cfdbinfo datasource="#session.dsn#" type="columns" table="#table_name#" name="cols"> line. I logout and log back in and try to access the tables and no log file shows up. Where would the log files be for the YAHOO widget??

Tony Garcia said on 09-27-2007 at 9:59 AM #

Another newb here with the same problem as Michael -- can't browse the tables at all. The Ajax Debug Log window isn't turning up any errors.
Don't know if this has anything to do with it, but sometimes (when I use the 'forward' and 'back' buttons on the browser) I get a popup window with this message: "Error processing JavaScript in markup for element main: [Enable debugging by adding 'cfdebug' to your URL perameters to see more information]" But, like Michael, adding cfdebug isn't giving me any info.

Raymond Camden said on 09-27-2007 at 5:35 PM #
	All I can think of is to try a script using <cfdbinfo> on the dsn. See if it works outside my application.

[Add Comment] [Subscribe to Comments]