Skip to main content
G
ghanna1
Inspiring
December 9, 2018
Answered

Variable within a Variable

  • December 9, 2018
  • 1 reply
  • 495 views

I have a form that allows the user to create 5 different sets of results on the same form. I do this by using CFLoop. For example:

<cfloop from=”1” to=“5” Index=“i”>

Form FieldName#i#

So I end up with:

FieldName1

FieldName2

FieldName3

FieldName4

FieldName5

That part works great and keeps the form code short and clean considering there are 16 form fields.

Is there a way to loop over that data to insert it into a table. Each Index needs to be its own row in the table. For example…

<cfloop from=”1” to=“5” Index=“z”>

<cfquery datasource = “abc”>

Insert into XYZ (Name)

Values (#form.FieldName[z]#)

</cfquery>

What I don’t know how to do is use a variable (the index) within a variable (Form.Result).  Parts of the form need to go into 6 different tables times 5 sections of the form would be 30 SQL statements vs. 6 if I can loop.

Thanks in advance for any assistance.

Gary

    This topic has been closed for replies.
    Correct answer ghanna1

    I found my answer....

    #form["name#z#"]#

    Basic Example:

    <cfif isdefined('form.submit')>

    <cfloop from="1" to="5" index="z">

    <cfoutput>#i# = #form["name#z#"]# </cfoutput><br></cfloop></cfif>

    <form method="post" action="">

    <input type="text" name="name1" id="name1"><br>

    <input type="text" name="name2" id="name2"><br>

    <input type="text" name="name3" id="name3"><br>

    <input type="text" name="name4" id="name4"><br>

    <input type="text" name="name5" id="name5"><br>

    <input type="submit" name="submit" id="submit" value="Submit"> </form>

    1 reply

    G
    ghanna1AuthorCorrect answer
    Inspiring
    December 9, 2018

    I found my answer....

    #form["name#z#"]#

    Basic Example:

    <cfif isdefined('form.submit')>

    <cfloop from="1" to="5" index="z">

    <cfoutput>#i# = #form["name#z#"]# </cfoutput><br></cfloop></cfif>

    <form method="post" action="">

    <input type="text" name="name1" id="name1"><br>

    <input type="text" name="name2" id="name2"><br>

    <input type="text" name="name3" id="name3"><br>

    <input type="text" name="name4" id="name4"><br>

    <input type="text" name="name5" id="name5"><br>

    <input type="submit" name="submit" id="submit" value="Submit"> </form>

    BKBK
    Community Expert
    BKBKCommunity Expert
    Community Expert
    December 9, 2018

    I am glad to see that you found the solution. Nevertheless, remember to insert the form values safely. Use, for example

    <CFQUERYPARAM VALUE="#form['name#z#']#" CFSQLType="CF_SQL_INTEGER">

    instead of just

    #form['name#z#']#

      G
      ghanna1Author
      Inspiring
      December 9, 2018

      Thank you for the reply and helpful suggestion. Off to my trusty friend google to figure out what cfqueryparam and cfsqltype do. I'm sure it's something valuable!

      Gary

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices