anyone can help how to use form validations in 
Coldfusion ? any url for this 

Sumeet

-----Original Message-----
From: David Gassner [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 07, 2000 6:06 PM
To: [EMAIL PROTECTED]
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.

Reply via email to