<cfquery name="qryFast">
SELECT oneColumnIsAllYaNeed FROM TableName WHERE KeyField = 0
<query>
<cfset x = qryFast.ColumnList>
or........
<cfquery name="qryFast">
SELECT * FROM TableName WHERE KeyField = 0
<query>
<cfset x = qryFast.ColumnList>
or maybe even...??? Havent tried this.....
<cfquery name="qryFast">
SELECT oneColumnIsAllYaNeed FROM TableName WHERE KeyField = 0
<query>
<cfwddx action="cfml2wddx" input="#qryFast.ColumnList#" output="x">
You may also find Paul Hasting's post from the allaire forums useful:
------------------------------------------
Date: March 25, 2000 02:36 PM
Author: Paul Hastings ([EMAIL PROTECTED])
jordan,
pick up the cf_SQL pack of custom tags from my site (www.tei.or.th/eic under
the free link). there's a custom tag in there to enumerate table columns.
---------------------------
All the best,
Steve
>
> Hello All,
> Is there a way/sql statement that would get me all
> the fields in the table? and store it in a variable ?
>
> something like
> <cfset x=Select Field_Names from Table_Name>
> so now x will have the values of the fields in the table.
>
> Appretiate all comments, thanks inadvance!
> Joe
>
>
>
> This message has been scanned for viruses using Sophos.
> The opinions stated in this message do not necessarily
> represent the opinions of e-MDs, its management or staff.
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in the body.
>
>
>
> -----
> Sent using MailStart.com ( http://MailStart.Com/welcome.html )
> The FREE way to access your mailbox via any web browser, anywhere!
>
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.