This is a multi-part message in MIME format.
--------------091FDA481ACC1A92D4AA4C0F
Content-Type: multipart/alternative;
boundary="------------C1EBA32865DA1B32DC8DB1B9"
--------------C1EBA32865DA1B32DC8DB1B9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Ryan -
It's not a custom tag.
To use it, run a query on the table (I've found that the table has to have a least one
populated row for this to work). Below the query, do something like:
<CFOUTPUT QUERY="suchandsuch">#columnlist#</CFOUTPUT>
That'll print out the names of all of the columns in the table.
For more info: do a Ctrl-Shift-E within Studio to bring up expression builder, go to
the variables section, and select ColdFusion Query Attributes. You'll see it listed
there. Double
click to see the syntax, or click on little Help icon below it for more info.
Steve Ray
Ryan Williams wrote:
> 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.
--------------C1EBA32865DA1B32DC8DB1B9
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Ryan -
<p>It's not a custom tag.
<p>To use it, run a query on the table (I've found that the table has to
have a least one populated row for this to work). Below the query, do something
like:
<p><CFOUTPUT QUERY="suchandsuch">#columnlist#</CFOUTPUT>
<p>That'll print out the names of all of the columns in the table.
<p>For more info: do a Ctrl-Shift-E within Studio to bring up expression
builder, go to the variables section, and select ColdFusion Query Attributes.
You'll see it listed there. Double click to see the syntax, or click on
little Help icon below it for more info.
<br>
<p>Steve Ray
<br>
<p>Ryan Williams wrote:
<blockquote TYPE=CITE>Sashidhar,
<p> What is getcolumnList? It isn't listed in either
my coldfusion help
<br>files or "Mastering ColdFusion" after market book I bought. Is
it a custom
<br>tag? Or some other type of function available in ColdFusion.
<p>Ryan
<br>[EMAIL PROTECTED]
<br>----- Original Message -----
<br>From: "Sashidhar V Thimmidi" <[EMAIL PROTECTED]>
<br>To: <[EMAIL PROTECTED]>
<br>Sent: Friday, July 07, 2000 6:12 AM
<br>Subject: Re: Retreiving Table Column Names???
<p>>
<br>> Hey
<br>>
<br>> use getcloumnlist
<br>>
<br>>
<br>>
<br>> --- Cold Fusion <[EMAIL PROTECTED]> wrote:
<br>> > Does anyone know how to retrieve table column names
<br>> > from an ODBC database? I know their is a way to do
<br>> > this in ASP using the open schema method but I don't
<br>> > know of a way in Cold Fusion. Any ideas are welcome.
<br>> >
<br>> > Thanks.
<br>> >
<br>> >
<br>> > __________________________________________________
<br>> > Do You Yahoo!?
<br>> > Send instant messages & get email alerts with Yahoo!
<br>> > Messenger.
<br>> > <a href="http://im.yahoo.com/">http://im.yahoo.com/</a>
<br>> >
<br>> --------------------------------------------------------------------------
<br>----
<br>> > To Unsubscribe visit
<br>> >
<br>> <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox</a>
<br>> > or send a message to [EMAIL PROTECTED] with
<br>> > 'unsubscribe' in the body.
<br>>
<br>>
<br>> =====
<br>> byeSashidhar V Thimmidi
<br>>
<br>> __________________________________________________
<br>> Do You Yahoo!?
<br>> Send instant messages & get email alerts with Yahoo! Messenger.
<br>> <a href="http://im.yahoo.com/">http://im.yahoo.com/</a>
<br>> --------------------------------------------------------------------------
<br>----
<br>> To Unsubscribe visit
<br><a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox</a>
or
<br>send a message to [EMAIL PROTECTED] with 'unsubscribe'
in
<br>the body.
<br>>
<p>------------------------------------------------------------------------------
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/fusebox</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------C1EBA32865DA1B32DC8DB1B9--
--------------091FDA481ACC1A92D4AA4C0F
Content-Type: text/x-vcard; charset=us-ascii;
name="sray.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Steve Ray
Content-Disposition: attachment;
filename="sray.vcf"
begin:vcard
n:;
tel;fax:703.838.9799
tel;work:703.838.9777
x-mozilla-html:TRUE
url:www.matrixgroup.net
org:Matrix Group International
version:2.1
email;internet:[EMAIL PROTECTED]
title:Developer/Hipster
adr;quoted-printable:;;801 N. Fairfax Street=0D=0ASte. 205;Alexandria;Virginia;22314;
fn:Steve Ray
end:vcard
--------------091FDA481ACC1A92D4AA4C0F--
------------------------------------------------------------------------------
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.
