Nick - I guess you wanted the number of columns rather than column names
which I assumed before,so to get that - either loop through the
ColumnList or use a CFquery to Database System tables and pass the table
name to get the number of columns..
Something like this below..
<cfquery name="getColumnsCount" datasource="DSN">
SELECT count(*) as colcount
FROM SYSTABLE
WHERE TABLENAME = '<Your Table Name>'
</cfquery>
Thanks.
-Sandy Vohra
-----Original Message-----
From: Vohra, Sandeep Singh
Sent: Monday, January 08, 2007 12:50 PM
To: '[email protected]'
Subject: RE: Counting the number of Fields in a dynamic table
queryname.ColumnList
and were you able to find an answer for the other question you had
around- Multiple Table Joins..SITEID etc..?
Thanks.
-Sandy Vohra
-----Original Message-----
From: Nick G [mailto:[EMAIL PROTECTED]
Sent: Monday, January 08, 2007 11:38 AM
To: CF-Newbie
Subject: Counting the number of Fields in a dynamic table
I have a search form which creates tables based on the users search
criteria. The number of records will be the same however the number of
fields in the table will change. Is there a feature similar to
"queryname.RecordCount" which gives the number of fields rather than the
number of records in a table?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2400
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
