Re: MS Access Primary Key
>>I was agreeing with you - you CAN'T directly get schema metadata through SQL. Oops, sorry, I read too fast ;-/ -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274799 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Access Primary Key
> > If I recall correctly, you can't directly get Access schema > > metadata through SQL. > > Right, but the info you can get is quite limited; you can get > a list of tables, I think columns too, and that's about it. I was agreeing with you - you CAN'T directly get schema metadata through SQL. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access Primary Key
>>f I recall correctly, you can't directly get Access schema metadata through SQL. Right, but the info you can get is quite limited; you can get a list of tables, I think columns too, and that's about it. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274697 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Access Primary Key
> And this link does not include any SQL examples, only VB. If I recall correctly, you can't directly get Access schema metadata through SQL. So, you'll probably have to get it another way, which very well may involve using COM; VB examples would be helpful for that. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! This email has been processed by SmoothZap - www.smoothwall.net ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274696 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MS Access Primary Key
And this link does not include any SQL examples, only VB. Thanks for trying tho. -john >2 second search in Google revealed: > >http://msdn2.microsoft.com/en-us/library/bb208516.aspx > > > > >"This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, >Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, >Registered in England, Number 678540. It contains information which is >confidential and may also be privileged. It is for the exclusive use of the >intended recipient(s). If you are not the intended recipient(s) please note >that any form of distribution, copying or use of this communication or the >information in it is strictly prohibited and may be unlawful. If you have >received this communication in error please return it to the sender or call >our switchboard on +44 (0) 20 89107910. The opinions expressed within this >communication are not necessarily those expressed by Reed Exhibitions." >Visit our website at http://www.reedexpo.com > >-Original Message- >From: John Stottlemire >To: CF-Talk >Sent: Thu Apr 05 06:55:52 2007 >Subject: Re: MS Access Primary Key > >Come on, someone has to know how to do this > >> Anyone know of a way to find the Primary Key in a table using CFMX and >> SQL? >> >> I know that queryname.columnlist returns the field names, but I'm >> trying to determine the primary key of the database table as well. >> >> Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274669 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access Primary Key
This works for SQL Server only. I ran into "these links" while doing my own searches on google and did not find anything that referenced MS Access. >Making a rapid search I found this link, it could help you > >http://blogs.msdn.com/sqltips/archive/2005/09/16/469136.aspx > >Greetings > >-Original Message- >From: John Stottlemire [mailto:[EMAIL PROTECTED] >Sent: Wednesday, April 04, 2007 11:56 PM >To: CF-Talk >Subject: Re: MS Access Primary Key > >Come on, someone has to know how to do this > >> Anyone know of a way to find the Primary Key in a table using CFMX and >> SQL? >> >> I know that queryname.columnlist returns the field names, but I'm >> trying to determine the primary key of the database table as well. >> >> Thanks in advance. ~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274668 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access Primary Key
>>Anyone know of a way to find the Primary Key in a table using CFMX and SQL? CFX_ODBCinfo will do this for you. You will need an ODBC connection on your datasource. See http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cfm -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274604 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: MS Access Primary Key
Making a rapid search I found this link, it could help you http://blogs.msdn.com/sqltips/archive/2005/09/16/469136.aspx Greetings -Original Message- From: John Stottlemire [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 04, 2007 11:56 PM To: CF-Talk Subject: Re: MS Access Primary Key Come on, someone has to know how to do this > Anyone know of a way to find the Primary Key in a table using CFMX and > SQL? > > I know that queryname.columnlist returns the field names, but I'm > trying to determine the primary key of the database table as well. > > Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274554 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access Primary Key
2 second search in Google revealed: http://msdn2.microsoft.com/en-us/library/bb208516.aspx "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com -Original Message- From: John Stottlemire To: CF-Talk Sent: Thu Apr 05 06:55:52 2007 Subject: Re: MS Access Primary Key Come on, someone has to know how to do this > Anyone know of a way to find the Primary Key in a table using CFMX and > SQL? > > I know that queryname.columnlist returns the field names, but I'm > trying to determine the primary key of the database table as well. > > Thanks in advance. ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS Access Primary Key
Come on, someone has to know how to do this > Anyone know of a way to find the Primary Key in a table using CFMX and > SQL? > > I know that queryname.columnlist returns the field names, but I'm > trying to determine the primary key of the database table as well. > > Thanks in advance. ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4