I've done this before:
<cfquery name="a">select * from table where 1==0</cfquery>
<cfoutput>a.ColumnList</cfoutput>
ColumnList is a comma delimited list of the fields. In conjuction with the "is<Type>"
functions you can get alot of information...
Larry
>>> [EMAIL PROTECTED] 07/07/00 07:30AM >>>
Sashidhar,
What is getcolumnList? It isn't listed in either my coldfusion help
files or "Mastering ColdFusion" after market book I bought. Is it a custom
tag? Or some other type of function available in ColdFusion.
Ryan
[EMAIL PROTECTED]
----- Original Message -----
From: "Sashidhar V Thimmidi" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 6:12 AM
Subject: Re: Retreiving Table Column Names???
>
> Hey
>
> use getcloumnlist
>
>
>
> --- Cold Fusion <[EMAIL PROTECTED]> wrote:
> > Does anyone know how to retrieve table column names
> > from an ODBC database? I know their is a way to do
> > this in ASP using the open schema method but I don't
> > know of a way in Cold Fusion. Any ideas are welcome.
> >
> > Thanks.
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Send instant messages & get email alerts with Yahoo!
> > Messenger.
> > http://im.yahoo.com/
> >
> --------------------------------------------------------------------------
----
> > To Unsubscribe visit
> >
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox
> > or send a message to [EMAIL PROTECTED] with
> > 'unsubscribe' in the body.
>
>
> =====
> byeSashidhar V Thimmidi
>
> __________________________________________________
> Do You Yahoo!?
> Send instant messages & get email alerts with Yahoo! Messenger.
> http://im.yahoo.com/
> --------------------------------------------------------------------------
----
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/fusebox or send a message
to [EMAIL PROTECTED] with 'unsubscribe' in the body.
