RE: Metadata 2
ODBC coneects you to a database. The type of the database determines what tables you have to look at to get the metadata. > -- > From: Juan Andres Alvarez Valenzuela[SMTP:[EMAIL PROTECTED]] > Sent: 29 September 2000 11:24 > To: CF-Talk > Subject: Metadata 2 > > sorry guys > > I forgot to mention I want to do that from ColdFusion using ODBC (ie. no > matter wich database is) > > ideas? > > gracias ; ) > > Juandres > > > > - Original Message - > From: JustinMacCarthy <[EMAIL PROTECTED]> > To: CF-Talk <[EMAIL PROTECTED]> > Sent: Friday, September 29, 2000 12:14 PM > Subject: Re: Medadata > > > > Hola Juan, > > > > > Anyone knows how can I get the metadata information from DB ? (ie. > > tables, > > > fields, primary keys, datatypes, views) > > > > In MsSql you can use the StoredProcs such called sp_tables witch will > > return all > > the tables in a DB including the sys tables. There are other that do > > different things , sp_columns etc... > > > > In Access you can get at the table names from a systable , it's called > > MsysObjects ,but it has alot of other stuff in there. To view the table > in > > access go to tools->options->view and tick > > hidden objects and system objects > > > > Hasta Lleugo > > > > ~Justin MacCarthy > > > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata 2
u could use the win32::odbc perl extension and get the table names that way, I think the method is tablelist() or something similair Stew -Original Message- From: Reynolds, Adam [mailto:[EMAIL PROTECTED]] Sent: 29 September 2000 11:46 To: CF-Talk Subject: RE: Metadata 2 ODBC coneects you to a database. The type of the database determines what tables you have to look at to get the metadata. > -- > From: Juan Andres Alvarez Valenzuela[SMTP:[EMAIL PROTECTED]] > Sent: 29 September 2000 11:24 > To: CF-Talk > Subject: Metadata 2 > > sorry guys > > I forgot to mention I want to do that from ColdFusion using ODBC (ie. no > matter wich database is) > > ideas? > > gracias ; ) > > Juandres > > > > - Original Message - > From: JustinMacCarthy <[EMAIL PROTECTED]> > To: CF-Talk <[EMAIL PROTECTED]> > Sent: Friday, September 29, 2000 12:14 PM > Subject: Re: Medadata > > > > Hola Juan, > > > > > Anyone knows how can I get the metadata information from DB ? (ie. > > tables, > > > fields, primary keys, datatypes, views) > > > > In MsSql you can use the StoredProcs such called sp_tables witch will > > return all > > the tables in a DB including the sys tables. There are other that do > > different things , sp_columns etc... > > > > In Access you can get at the table names from a systable , it's called > > MsysObjects ,but it has alot of other stuff in there. To view the table > in > > access go to tools->options->view and tick > > hidden objects and system objects > > > > Hasta Lleugo > > > > ~Justin MacCarthy > > > > > > > -- > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > > -- > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or > send a message to [EMAIL PROTECTED] with 'unsubscribe' in > the body. > ** This email and any attachments are confidential and solely for the use of the intended recipient. They may contain material protected by legal professional or other privilege. If you are not the intended recipient or the person responsible for delivering to the intended recipient, you are not authorised to and must not disclose, copy, distribute or retain this email or its attachments. Although this email and its attachments are believed to be free of any virus or other defect, it is the responsibility of the recipient to ensure that they are virus free and no responsibility is accepted by the company for any loss or damage arising from receipt or use thereof. ** -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
RE: Metadata 2
What kind of metadata you are looking for? I can give you some sample code/pointers on how to do a CFX (C++). I did mine out of a sample from MSDN (called cat.cpp or something like that). Uses MFC and other crap, but if you compile it in a single DLL you should be OK. They do many things metadata queries, and can be easily, but tediously extended. -Original Message- From: Juan Andres Alvarez Valenzuela [mailto:[EMAIL PROTECTED]] Sent: Friday, September 29, 2000 3:25 AM To: CF-Talk Subject: Metadata 2 sorry guys I forgot to mention I want to do that from ColdFusion using ODBC (ie. no matter wich database is) ideas? gracias ; ) Juandres - Original Message - From: JustinMacCarthy <[EMAIL PROTECTED]> To: CF-Talk <[EMAIL PROTECTED]> Sent: Friday, September 29, 2000 12:14 PM Subject: Re: Medadata > Hola Juan, > > > Anyone knows how can I get the metadata information from DB ? (ie. > tables, > > fields, primary keys, datatypes, views) > > In MsSql you can use the StoredProcs such called sp_tables witch will > return all > the tables in a DB including the sys tables. There are other that do > different things , sp_columns etc... > > In Access you can get at the table names from a systable , it's called > MsysObjects ,but it has alot of other stuff in there. To view the table in > access go to tools->options->view and tick > hidden objects and system objects > > Hasta Lleugo > > ~Justin MacCarthy > > > -- > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. -- Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
