IMHO if people are using Access, they aren't likely to be using reactor ...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Doug Hughes Sent: 20 February 2006 17:33 To: [email protected] Subject: RE: Reactor For CF Access help I've already gone down that route. The Access/ODBC driver doesn't support it. It appears to be optional. I wonder if I couldn't use some COM objects to do this? (Though that would be os/platform specific.) I don't know that many people will be using access with reactor anyhow, so I'm not too worried. Doug -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Cedric Villat Sent: Monday, February 20, 2006 12:30 PM To: [email protected] Subject: RE: Reactor For CF Access help 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/ -- 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/

