*So each time the form is submitted, you'll be inserting new records into a database table? *
Yes *Also, the first input is a checkbox that passes the users.employeeID if checked - what is the expected value if the checkbox is not checked?* If its not checked it won't be submitted. On Fri, Jan 28, 2011 at 2:12 PM, Carl Von Stetten <[email protected]>wrote: > > So each time the form is submitted, you'll be inserting new records into > a database table? Also, the first input is a checkbox that passes the > users.employeeID if checked - what is the expected value if the checkbox > is not checked? > > What is the structure of the table you are inserting to? > > On 1/28/2011 10:46 AM, Monique Boea wrote: > > New records. See code below. > > > > I need to parse through the submitted fields to insert them. > > > > I think I am making it much harder then what it is but I'm SO stuck. > > > > Here's the code that I am working with to process the form fields: > > > > <cfif isDefined("form.submit")> > > <cfloop From="1" To= "#users.recordcount#" index="i"> > > <cfloop item="fname" collection="#form#"> > > <cfoutput><cfif #form[fname]# NEQ > "">#Evaluate("form[fname]"& > > i)#<br /></cfif></cfoutput> > > </cfloop> > > </cfloop> > > > > </cfif> > > > > > > Here's the form > > > > > > <cfloop query="users"> > > <cfif users.roleID NEQ 1> > > <tr> > > <td><input name="userID#userID#" type="checkbox" > value="#users.employeeID#"> > > #users.firstname# #users.lastname#</td> > > <td> > > <CFSELECT NAME="code#userID#"> > > <OPTION value=""></option> > > <OPTION value="Personal">Personal</option> > > <OPTION value="Preceptor">Preceptor</option> > > <OPTION value="Senior Resource Nurse">Senior Resource Nurse</option> > > <OPTION value="Special Project-Phone">Special Project-Phone</option> > > <OPTION value="System Down Time">System Down Time</option> > > <OPTION value="Training-In Person">Training-In Person</option> > > <OPTION value="Training: Phone">Training: Phone</option> > > <OPTION value="Client Training Phone">Client Training Phone</option> > > <OPTION value="Peer To Peer Consultation">Peer To Peer > Consultation</option> > > <OPTION value="Gone Home">Gone Home</option> > > </CFSELECT> > > </td> > > <td><input name="minutes#userID#" value="" size="5"></td> > > </tr> > > </cfif> > > </cfloop> > > > > On Fri, Jan 28, 2011 at 1:43 PM, Carl Von Stetten > > <[email protected]>wrote: > > > >> Some more information might be helpful. Can we see the code of the form > >> itself? Also, are you just inserting new records into your database, or > >> editing existing records? > >> > >> On 1/28/2011 10:34 AM, Monique Boea wrote: > >>> Any sample code for a grid-like form? > >>> > >>> > >>> > >>> On Thu, Jan 27, 2011 at 8:16 PM, Monique Boea<[email protected]> > >> wrote: > >>>> Hello All > >>>> > >>>> I have a form which is design like an excel spreadsheet with about 60 > >> input > >>>> rows. > >>>> > >>>> The user may enter values for some and not the others. > >>>> > >>>> I am stuck on entering the values into the database. > >>>> > >>>> I use the following code to loop through the forms vars but don't know > >>>> where to go after this. > >>>> > >>>> <cfloop list="#StructKeyList(form)#" index="key"> > >>>> <cfif #form[key]# NEQ "Submit" AND #form[key]# NEQ "FIELDNAMES"> > >>>> <cfoutput>#key# = #form[key]#<br></cfoutput> > >>>> </cfif> > >>>> </cfloop> > >>>> > >>>> > >>>> Any suggestions? > >>>> > >>>> P.S. Thank you guys for all of your help. It is appreciated. > >>>> > >>> > >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
