Each CFQuery has a ColumnList property:
<CFQUERY Name="GetColumns" ...>
Select * from mytable
</CFQUERY>
<CFOUTPUT>
#GetColumns.ColumnList#
</CFOUTPUT>
HTH,
Noam
----------
From: Ryan Williams [SMTP:[EMAIL PROTECTED]]
Sent: Friday, 07 July 2000 15:31
To: [EMAIL PROTECTED]
Subject: Re: Retreiving Table Column Names???
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?sidebar=lists&body=lists/fusebox or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
