I believe that I am getting confused on the terms being used. Are you
referring to the ability to reference the specific column name from a query
by doing something like:
<cfquery Name="qGetUserInfo" Datasource="Users">
select UserID,UserFirstName,UserLastName...
from Users
</cfquery>
<cfoutput>
#qGetUserInfo.UserID#
</cfoutput>
Is this what was meant by the original reply "Hey
use getcloumnlist" ?
Ryan
[EMAIL PROTECTED]
----- Original Message -----
From: "BOROVOY Noam" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, July 07, 2000 10:11 AM
Subject: RE: Retreiving Table Column Names???
> 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.
>
------------------------------------------------------------------------------
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.
