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:341655
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
