To reply to your request for an Orange with an Apple, why not write a thin wrapper around java.sql.DatabaseMetaData?
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html particularly http://java.sun.com/j2se/1.4.2/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[]) someDataSource.getConnection().getMetaData will give you this info, and it's available in jdk1.4.2 (at least). You have to resort to some trickery to actually get a DataSource Object in CF 6 (and possibly 7?) but I understand that it's possible? Quick googling found http://spike.oli.tudelft.nl/jochemd/index.cfm?PageID=12 but I'm not sure which cf version this is applicable to. Mark Mandel wrote: > Yes, but I'm writing framework code, that is supporting multiple > versions of products, so, there is no 'you must be on CF8'. > > Basically, if the feature is there, I want to use it, and if it isn't > there, I want it to scale down gracefully. > > I can say all this one more time, if you would like ;o) > > Mark > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---