Take variables and set new ones based on variable values

I have a form like this:

<input type="Text" name="OtherProject" required="No" size="1" maxlength="3" value="">
<CFLOOP from="100" to="750" step="50" index="taskID">
  <input type="Text" name="task#taskID#_Other" required="No" size="1" maxlength="4" value="">
</CFLOOP>

As you can see the second form field is inside of a loop, so it generates an array of 14 fields.

So for example the first form would be passed as such:

form.OtherProject=400

And the second as such:

form.task100_Other=5
form.task450_Other=2.5
form.task500_Other=11

So what I need is for the recieving file to set variables where Other is replaced by the number passed by form.OtherProject:

form.task100_400=5
form.task450_400=2.5
form.task500_400=11

Notice how some of the second form fields are left blank in my example, it should be programmed so that is ok.

Thank you for your help.
Max_DavisAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PE_CF_DEVCommented:
I don't think I understnad exactly what you want here...

After the form is submited you want to then make a new form with the names task450_400? Or you want to be able to access form.task100_400?

Maybe any code you have available would help us understand it?

0
shooksmCommented:
On the receiving page:

<CFLOOP from="100" to="750" step="50" index="taskID">
     <CFIF IsDefined("FORM.task#taskID#_Other") EQ True>
          <CFSET "FORM.task#taskID#_#FORM.OtherProject#" = Evaluate("FORM.task#taskID#_Other")>
     </CFIF>
</CFLOOP>
0
jyokumCommented:
i think it would be easier if you didn't use _Other on your original form, then you could just append the OtherProject value rather than trying to replace part of a variable name

<!--- page1.cfm --->
<cfoutput>
<form name="frmData" action="page2.cfm" method="post">
Other Project<input type="Text" name="OtherProject" required="No" size="1" maxlength="3" value=""><br>
<cfloop from="100" to="750" step="50" index="taskID">
  <input type="Text" name="task#taskID#" required="No" size="1" maxlength="4" value=""><br>
</cfloop>
<input type="submit">
</form>
</cfoutput>


<!--- page2.cfm --->
<cfloop from="100" to="750" step="50" index="taskID">
  <cfif isDefined('form.task#taskID#')>
  <input type="Text" name="task#taskID#_#form.OtherProject#" required="No" size="1" maxlength="4" value=""><br>
  </cfif>
</cfloop>
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

anandkpCommented:
if i understand u correctly - this shld help

run a loop on the submitted page as :

<CFLOOP FROM="100" TO="750" STEP="50" INDEX="taskID">
      <CFIF ISDEFINED('TASK#TASKID#_OTHER') AND LEN(TRIM(EVALUATE('TASK#TASKID#_OTHER')))>            
            #task#taskID#_Other# = #evaluate('task#taskID#_Other')#<BR>
      </CFIF>
</CFLOOP>

& see what output u get [it will pring only those form fields that u have NOT left blank]

let me know ...

K'Rgds
Anand
0
PluckaCommented:
I think you want to use dynamic variables. When setting dynamic variables it's easy.

Ie

<cfset Test = "Hello">
<cfset "More#Test#" = "There">

<cfoutput>#MoreHello#</cfoutput>

To check for existance or value of a dynamic variable, you need to use IsDefined & evaluate.

Ie

<cfif IsDefined("More#Test#")>
    The variable MoreHello is defined.
</cfif>

<cfif Evaluate("More#Test#") eq "There">
    Yes we can do logical comparrisons!
</cfif>
0
proceptCommented:
Hi,

if I understand you correctly, you want to set the new variables only if the "_other" vars are not empty? The following code will do that:

<cfloop collection="#form#" item="field">
   <cfif right(field, 6) EQ "_Other">
      <cfif len(trim(form[field]))>
         <cfset form[replaceNoCase(field, "other", taskID, "ALL")] = form[field]>
      </cfif>
   </cfif>
</cfloop>
0
CFDevHeadCommented:
<cfif IsDefined("OtherProject")>
<CFLOOP from="100" to="750" step="50" index="taskID">
      <cfif ISDEFINED('TASK#TASKID#_OTHER') AND LEN(TRIM(EVALUATE('TASK#TASKID#_OTHER')))>          
          <cfset temp=evaluate('task#taskID#_Other='& #evaluate('task#taskID#_Other')#)>
     </cfif>
</CFLOOP>
      </cfif>
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
anandkpCommented:
weird !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.