<div>
You can access <br />
<br />
#form.fieldnames# to get the fieldnames<br />
<br />
e.g.<br />
<br />
&lt;cfloop item=&quot;fname&quot; collection=&quot;#form#&quot;&gt;<br />
&lt;cfoutput&gt;#fname# - #form[fname]#&lt;br&gt;&lt;/cfoutpu<wbr />t&gt;<br />
&lt;/cfloop&gt;<br />
<br />
<br />
Use this information to build select statement<br />
<br />

</div>


You can access

#form.fieldnames# to get the fieldnames

e.g.

<cfloop item="fname" collection="#form#">
<cfoutput>#fname# - #form[fname]#<br></cfoutput>
</cfloop>


Use this information to build select statement



<div>
<div class="content wysiwyg-content">
Working away on a little CRM type tool and I am a little stumped.<br />
<br />
here is the issue I have.<br />
<br />
Page1.cfm <br />
asks for number of lines to work with (called portnum) <br />
<br />
Calls page2.cfm portnum is passed over in a session variable<br />
<br />
I loop on the form to show a input field for each line<br />

<pre><code id="code-10-26971247-1">&lt;cfloop from=&quot;1&quot; to=&quot;#session.portingfields.portnum#&quot; index=&quot;counter&quot;&gt;
  &lt;cfoutput&gt;
           	&lt;cfinput type=&quot;text&quot; name=&quot;number_#counter#&quot; value=&quot;&quot; size=&quot;8&quot;&gt;&lt;br&gt;
  &lt;/cfoutput&gt;
&lt;/cfloop&gt;</code></pre>
and it calls writelines.cfm on submit<br />
<br />
my issue is how to write it out to the sql after the person enters the details. &nbsp; I am thinking that i build the insert string in writelines.cfm on the fly. &nbsp;Am I right in this thinking or is their an easier way ?<br />
<br />
thanks
</div>
</div>


Working away on a little CRM type tool and I am a little stumped.

here is the issue I have.

Page1.cfm 
asks for number of lines to work with (called portnum) 

Calls page2.cfm portnum is passed over in a session variable

I loop on the form to show a input field for each line
(CODE)
and it calls writelines.cfm on submit

my issue is how to write it out to the sql after the person enters the details.   I am thinking that i build the insert string in writelines.cfm on the fly.  Am I right in this thinking or is their an easier way ?

thanks

dynamically building a select statement in coldfusion.

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.