Thanks David, that works! cool
----- Original Message -----
From: "David Gassner" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 07, 2000 9:05 PM
Subject: RE: dynamic data sets?? outputs?
> 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.
>
------------------------------------------------------------------------------
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.
