>>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:242192
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
