count number of columns in a table 1

[joelxez]

hi experts,

any tips on how to count number of columns in a table?

j

 

[ecobb]

<cfquery name="query_name">
SELECT *
FROM Whatever
</cfquery>

<cfoutput>
   #ListLen(query_name.columnList)#
</cfoutput>

If you didn't want any results from your query (you were only going to use it for the column count), you could use this:

<cfquery name="query_name">
SELECT *
FROM Whatever
WHERE 0 = 1
</cfquery>

Hope This Helps!

Ecobb

"My work is a game, a very serious game." - M.C. Escher

 

[joelxez]

great, tanx ecobb