> I'm leveraging the metadata to get the ordinal order of > the columns instead of the lovely alphabetical order of > columns, which MM's coldfusion throws at you. You can > make some really nice code generation tools with the > metadata as far as making DAOs and Beans ect. Previously > I used to query sysobjects but that didn't work so > well with anyhting other than MS SQL.
I'll probably be rewriting the onTap framework's db meta-data tools to optionally use the admin API myself (given availability of the admin password). I've been using the serviceFactory to get access to databaseMetadata objects. I'm not sure why the ordinal position of columns in the database should matter tho... :-/ s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://www.sys-con.com/author/?id=4806 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:206959 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
