ODBC also. I'm guessing it uses COM.
http://www.contentbox.com/claude/customtags/ODBCInfo/E/TestODBCInfo.cf
m?p=
Personally I'd love to know enough C to be able to write something in
a CF5 compatible UDF that would get that info -- it'd fill in some
gaps with CF5 and MS Access in the meta-data features in the onTap
framework. But as of yet it remains a mystery - info on MS site is
cryptic and I haven't had time to find or read any books that would
explain it.
> If you have an ODBC connection, or can make one, according
> to Microsoft's website there are catalog functions built
> into ODBC that returns database information. Here is the
> link to the info in MSDN:
> http://msdn.microsoft.com/library/default.asp?url=""> > /en-us/odbc/htm/odbccatalog_functions_in_odbc.asp
> Might or might not help!
> ______________________________________________________
> <file:///E:/EUColor.gif>
> Bill Grover
> Manager, Information Systems Phone: 301.424.3300 x3324
> EU Services, Inc. FAX: 301.424.3696
> 649 North Horners Lane E-Mail:
> <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
> Rockville, MD 20850-1299 WWW:
> <http://www.euservices.com/> http://www.euservices.com
> ______________________________________________________
> -----Original Message-----
> From: Stephen Milligan [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 07, 2004 5:25 PM
> To: CF-Talk
> Subject: RE: Find out table names and fields?
> You can also dig down to the java level and do this in a
> database
> independent way through the
> macromedia.jdbc.MacromediaDriver class if you
> need to support more than just MSSQL and MySQL.
> I have written a CFC that does this, but I haven't tested
> it on many
> systems.
> I'll try to get it tidied up and make it available once
> it's been tested a
> bit more thoroughly.
> Spike
> --------------------------------------------
> Stephen Milligan
> Code poet for hire
> http://www.spike.org.uk
> Do you cfeclipse? http://cfeclipse.tigris.org
>>-----Original Message-----
>>From: [EMAIL PROTECTED]
>>[mailto:[EMAIL PROTECTED] On Behalf Of S.Isaac
>>Dealey
>>Sent: Wednesday, July 07, 2004 1:13 PM
>>To: CF-Talk
>>Subject: Re: Find out table names and fields?
>>
>>Those are specific to MySQL - MS SQL uses standard tables,
>>views and
>>sql queries to expose its meta data. i.e.
>>
>>select * from information_schema.columns
>>where table_name = 'mytablename'
>>
>>and the like
>>
>>s. isaac dealey 214.823.9345
>>
>>new epoch : isn't it time for a change?
>>
>>add features without fixtures with
>>the onTap open source framework
>>http://www.sys-con.com/story/?storyid=44477&DE=1
>>
>>> how do i dump the results to display on the page? Will
>>> this only work for mySQL, or for MS SQL as well?
>>
>>> thanks!
>>> ----- Original Message -----
>>> From: Barney Boisvert
>>> To: CF-Talk
>>> Sent: Wednesday, July 07, 2004 3:42 PM
>>> Subject: RE: Find out table names and fields?
>>
>>
>>> Sure, run these queries, and dump the result.
>>
>>> `show databases` will list all databases you have
>>> access
>>> to via the DSN.
>>> `show tables` will list all tables in the database the
>>> DSN is connected to.
>>> `show tables in <dbname>` will list all tables in the
>>> named database.
>>> `explain <tablename>` will list the columns of the
>>> named
>>> table. You can use
>>> cross-database tables by saying <dbname>.<tablename>
>>
>>> Cheers,
>>> barneyb
>>
>>> > -----Original Message-----
>>> > From: brobborb [mailto:[EMAIL PROTECTED]
>>> > Sent: Wednesday, July 07, 2004 1:26 PM
>>> > To: CF-Talk
>>> > Subject: Find out table names and fields?
>>> >
>>> > Hey guys, I have a host that has no web admin
>>> > support
>>> > for
>>> > mySQL. I mean, they have MySQL running, but no
>>> > admin.
>>> > At
>>> > least thats what I'm told by my client. I was
>>> > wondering if
>>> > there was a way to extract the table names and
>>> > fields
>>> > using
>>> > coldfusion instead. Would that be possible?
>>> >
>>> >
>>
>>
>>>
>>
>>
> _____
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
