> 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists