I would think you would be able to extract this information for all database types using the underlying java routines. I'm not positive, just seems possible.
Cedric -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Short Sent: Monday, February 20, 2006 9:21 AM To: [email protected] Subject: RE: Reactor For CF Access help Hi Doug, I'm not sure how useful this will be (given that it's ASP code), but I wrote this for extracting data types off of database tables (works on Access and SQL Server without issue). You know we have to write all this functionality that CF builds in when working with "other" languages :). Dan > I didn't feel like being productive this morning so I decided > to try to create an adaptor for Access. I can get *almost* > all the information I need. Unfortunately, I can't find a > way to find out what columns are in an access table nor > information such as if it's a PK, autonumbered, Nullable, > it's datatype, size or default value. Anyone have any ideas > on how I could get that? With that, we'd have one more > adaptor, albeit a somewhat useless one. -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/ -- Reactor for ColdFusion Mailing List -- [email protected] -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/
