> Add a counter
> <cfset i = 0>
> <CFLOOP Query="GetFields">
> <cfset i = #1#+1>
> <CFQUERY name="GetValues" datasource="#dsn#">
> SELECT #GetFields.FieldName#
> FROM #TableName#
> WHERE ID=#ID#
> </CFQUERY>
> <CFSET
> DefaultValue=evaluate("GetValues.#GetFields.FieldName#")>
Oops, no - time for the evaluate police. To get a dynamic column/row
from a query, just do:
<cfset x = getValues[colname][rownum]>
> <CFINPUT Name="#GetFields.FieldName##i#"
> value="#DefaultValue#">
> </CFLOOP>
>
=======================================================================
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email : [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally it is." - Yoda
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
