>>I am trying to pull the metadata out of the database but it seems that Oracle and SQL don't support the same methods for querying that metadata.
Sure. All this is non SQL standard, so every one is doing it HIS way, some are not even doing it. The advantage of doing it through ODBC like CFX_ODBCinfo does is that everything is returned in the same query, no matter the DB type. CFX_ODBCinfo only uses features standard in ODBC and available through the ODBC driver. >> For Oracle, it looks like I will be querying ALL_TAB_COLUMNS and for SQL Server it's a query to INFORMATION_SCHEMA. CFX_ODBCinfo makes no SQL query to the datasource, it only calls C functions in the ODBC package and creates ColdFusion queries with the information provided by the driver. >> I guess I could make a config that sets the DB type and do my queries accordingly, but I was curious if anyone knew other ways to query the database systems to get the data out. You could, of course, but for the price, you would be much better with CFX_ODBCinfo ;-) -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:218437 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
