get field names 1

[TruthInSatire]

I thought I saw this somewhere but I can't seem to find it.

How can i grab the field names from a table?

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
- Quote by Douglas Adams

 

[csteinhilber]

#[i]queryname.ColumnList[/i]#

will give you a comma-separated list of column names.


-Carl

 

[TruthInSatire]

I knew it was something simple. thanks.

A common mistake that people make when trying to design something completely foolproof is to underestimate the ingenuity of complete fools.
- Quote by Douglas Adams

 

[patrickturner]

Is there a way to spit out column properties too? nvarchar(25) Null, etc. ??

 

[csteinhilber]

I don't think so... not without querying the main system table in your database. The method of doing that is quite dependent on which database you're using (if the particular database even has a system table)


-Carl

 

[cfvogue]

if you're using CFMX with mysql, as i am, you can simply do the following:

<cfquery name=&quot;MyQueryName&quot; datasource=&quot;...>
describe table
</cfquery>

<cfdump var=&quot;#MyQueryName#&quot;>

N.B requires MX version of ColdFusion

chau