No worries. I'm always around if you have questions about it. :) I just wasn't sure if you'd seen the last post -- I figured you might have missed it in your inbox if you're like me and have hundreds of messages and end up deleting a lot of them unread.
> Yeah, I read through it once already, but I'm not a big on > java (just > because I don't know it). But let me go read through it > again. > Mike > S. Isaac Dealey wrote: >>>> >>Do you look at the db type and then query it >>>> >>accordingly? >>>> >>>>Actually not, this is the beauty of ODBC: it is (well >>>>almost) DB >>>>independant. >>>>The only things that are DB dependent are a couple of >>>>things (flaws) not >>>>supported by some ODBC drivers. >>>> >> >> >>>This is what I was curious about. 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. For Oracle, it looks >>>like I will be >>>querying ALL_TAB_COLUMNS and for SQL Server it's a query >>>to >>>INFORMATION_SCHEMA. 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. >> >> >> Yep, that's why I use JDBC... Here's the article: >> >> http://coldfusion.sys-con.com/read/45569.htm 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://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:218443 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
