Working away on a little CRM type tool and I am a little stumped.
here is the issue I have.
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
<cfloop from="1" to="#session.portingfields.portnum#" index="counter">
<cfinput type="text" name="number_#counter#" value="" size="8"><br>
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 ?