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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:218440 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
