Joe, if you want to see the field names, try this:
<cfquery Name="Get_fields" datasource="Personal">
Select * from table_name
</cfquery>
<cfloop list="#get_fields.columnlist#" index="fieldname">
<cfoutput>#fieldname#<br></cfoutput>
</cfloop>
If you want to see the data:
<table>
<cfoutput query="get_fields">
<tr>
<cfloop list="#get_fields.columnlist#" index="fieldname">
<td>
#evaluate("get_fields.#fieldname#")#
</td>
</cfloop>
</tr>
</cfoutput>
</table>
David Gassner
Vintage Business Applications
> -----Original Message-----
> From: Joseph Eugene [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April 07, 2000 5:37 PM
> To: [EMAIL PROTECTED]
> Subject: dynamic data sets?? outputs?
>
>
> Hello all,
> I am using this code to find the fields in the
> table & i want
> to dynamically generate the output.
>
> <cfquery Name="Get_fields" datasource="Personal">
> Select * from table_name
> </cfquery>
> <cfoutput>
> <cfset x=#ListLen(Get_Fields.ColumnList)#>
> #x#<br>
> </cfoutput>
> <cfloop index="z" from="1" to="#x#">
> <cfset output=#GetToken(Get_Fields.ColumnList, #z#, ",")#>
> <cfoutput>#output#</cfoutput>
> </cfloop>
>
> how can i output the fields of the table, i tried different
> things, cant get
> it to work.
> Thanks inadvance, appretiate it.
>
> Joe
>
>
>
> ------------------------------------------------------------------
> ------------
> 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.
