Hey there,
Sorry for the newbie question, but...
I have a form that posts to an action page. The form page is working like I
want it to. It loops over a query and gives me a list of variables like
so...
variableA#i#
variableB#i#
variableC#i#
where the value of #i# will be usually 1-100 +/-
I am having difficulty with the action page. I am guessing I need to use
evaluate(variableA, [#i#]) or something but I cannot get it to work for
nothing.
Here is what I have been trying to get to work (the action page):
<!---set variables--->
<cfset areaId ="">
<cfset jobId ="">
<cfset areaName ="">
<cfset laborStep ="">
<cfset NumMin = "">
<!---loop over form variables--->
<cfloop index="i" from="1" to="#form.maxValue#">
<cfset jobId = Evaluate("form.jobId[#i#]")>
<cfset areaName =Evaluate("form.roomName[#i#]")>
<cfset laborStep =evaluate("form.laborStep[#i#]")>
<cfset NumMin =evaluate("form.NumMin[#i#]")>
<cfset areaId = evaluate ("form.areaId[#i#]")>
<!---insert record--->
<cfquery name="JobSetup" datasource="mdfinish">
INSERT INTO LaborTracking (
AreaId,
JobId,
AreaName,
LaborStep,
NumberMinutes
)
VALUES (
#AreaId#,
#JobId#,
'#areaName#',
'#laborStep#',
#NumMin#
)
</cfquery>
</cfloop>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:217694
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
