Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
quote:
Originally posted by: cutie369
This worked for me.
<cfif isdefined("theSQLQuery2")><cfdump label="SQL" var="#theSQLQuery2#"></cfif>
<cfquery dbtype="query" name="getthis">
Select * from theSQLQuery2
</cfquery>
<cfdump var="#getthis#">
<h3>Create configuration settings</h3>
<table width="800" border="1" cellspacing="0" cellpadding="0">
<cfloop list="#theSQLQuery2.ColumnList#" index="ColumnName">
<tr>
<th scope="row"><cfoutput>#ColumnName#</cfoutput></th>
<td><input name="<cfoutput>#ColumnName#</cfoutput>" <cfif ColumnName EQ "CONFIGID">type="hidden"<cfelse>type="text"</cfif> value="<cfoutput>#Evaluate("theSQLQuery2." & ColumnName)#</cfoutput>" size="30"></td>
</tr>
</cfloop>
</table>
I know I am taking a performance hit with evaluate. Is there a better way of doing this.
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied
Copy link to clipboard
Copied