There is also a cfmyadmin. I don/t remember the addy, but if you google cfmyadmin, you will find it. It's basically the cf version of phpmyadmin
Eric -----Original Message----- From: Claude Schneegans [mailto:[EMAIL PROTECTED] Sent: Friday, 02 June 2006 20:54 To: CF-Talk Subject: Re: Generic database management tool >>Is anyone out there using any kind of generic database management scripts. I have something like that presently on the back burner. It is called "ODBCMyAdmin", although the name might change since is also handles JDBC databases now. The basic idea is PHPMyAdmin, although more powerful, written in CF and can handle any ODBC or JDBC datasource. The main features are: - All writen in CF and Javascript, compatible with IE. - 100% compatible CF 5 and CFMX, ODBC and JDBC; - all tables and column names drown from the datasource itself: no name to type; - can produce <CFQUERY code for SELECT, INSERT, UPDATE DELETE on any table; - can generate <CFQURYPARAM automatically, based on column types on request; - can produce a <FORM using any fields on any table; some fields may be <SELECT with options generated from any other table; all field length and maxlength suggested by default from info from the table specs in the datasource. - "advanced query buider" à la Access, with all types of JOINS, GROUP, WHERE, HAVING etc. clauses; even UNIONs are supported (not in Access) - Browse all tables, columns, queries; - direct acces to the tool from CF Studio; ALL above without using any key on your keyboard, only the mouse. - add, edit, delete columns in any table; - add, edit, delete indexes in any table; - add, edit, delete tables in any datasource; - and of course "much more" ! ;-) I use it a lot for myself; my only problem before I can release it are 1º time to finish testing and document it; 2º some native speaking fellow, fluent in French, who would help me with the docs and online help. May be some work for long nights, next winter... -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242201 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
