If anyone is interested here is how I got this to work FINALLY!!
INSERT INTO nonproductivetime (
employeeID,
reason,
time,
addedby)
VALUES (
#form["employeeID#i#"]#,
'#form["reason#i#"]#',
#form["time#i#"]#,
'#session.user.username#'
)
On Fri, Jan 28, 2011 at 7:46 PM, Monique Boea wrote:
> Hello all.
>
> I have been trying to figure this out all day. Any assistance would be
> appreciated.
>
> I have a dynamic form that is in grid format:
>
>
> cellpadding="5" cellspacing="5">
> Use the form below to
> enter non-productive time for agents. NOTE: Please enter time as
> minutes
>
>
>
>
> AGENTREASON
> CODEMINUTES
>
>
>
> value="#users.employeeID#"> #users.firstname# #users.lastname#
>
>
>
> Personal
> Gone Home
>
>
>
>
>
>
>
> value="submit">
>
>
>
>
>
>
> When the form is submitted, I need to be able to insert the variables in
> the db:
>
> I have the following code that I am able to get the values of the form vars
> with but I don't know where to go from here:
>
>
>
>
>
>
>
> NEQ "FIELDNAMES">
> #fname# - #form[fname]#
>
>
>
>
> INSERT INTO nonproductivetime (
> employeeID,
> code,
> minutes)
> VALUES (
> ,
>
> ,
> value="#form[fname]#">
> )
>
>
>
>
>
>
>
>
>
~|
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:341683
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm