CODEWITHSUNDEEP
sql-serverformscoldfusioncfloop
Jdav
Jdav

Reputation: 13

Form values using cfloop index

I'm using a cfloop to create a form and populate text fields with values from a database query. I also created an array. It is returning "depthinput1", "deptinput2", and so on in the input boxes, instead of the values in the database fields. Any help would be appreciated.

<cfloop index="i" from="0" to="#totalsegment-1#">
    <cfloop query="flowQy" startrow="1" endrow="#totalsegment-1#">

    <cfset newarray =ArrayNew(1)>
    <cfset depthinput=structNew()>
    <cfset depthinput[i] = "depthinput" & i>
    <cfset arrayAppend(newarray, depthinput)>
    <cfinput name="depthinput#i#"  tabindex="#((i+1)*2)-1#" type="text"  onfocus="this.value='';findTotal();" size="10" onblur="findTotal();" value='#depthinput[i]#'  id="depthinput#i#"></cfinput></br>

    </cfloop>
</cfloop>

Image of Form

Upvotes: 0

Views: 484

Answers (2)

SOS
SOS

Reputation: 6550

Without a data dump, it's difficult to tell how the data is actually stored, which makes the question a little confusing.

Are "depthinput1", "depthinput2" the names of columns in the query?

RecordID | DepthInput1 | DepthInput2 | ... | DepthInputN
1        |     35.5    | 86.2        | ... |    14.6

... OR are the "depthInput" values actually stored in separate rows ?

RecordID | DepthInput 
1        |    35.5    
2        |    86.2 
....
86       |    14.6

If they're query columns, consider restructuring the database table. Similar column names like "thing1", "thing2", ... are usually an indicator the data should be stored in separate rows (like above). If you really can't change the structure, use associative array notation to access the query columns dynamically, queryName["columnName"][rowNumber]#:

<cfoutput query="flowQy">
   <!--- determines which columns to display:  -->
   <cfloop from="0" to="#totalSegment#" index="i">
    <input name="depthInput#i#" value="#flowQy['depthInput'& i+1][flowQy.currentRow]#"><br>
   </cfloop>
</cfoutput>

If the values are actually stored in separate rows, just loop through the query and use queryName.currentRow as an index.

<cfoutput query="flowQy">
    <input name="depthInput#flowQy.currentRow-1#" 
        value="#flowQy.depthInput#"><br>
</cfoutput>

Upvotes: 2

Leeish
Leeish

Reputation: 5213

I think you want something more like:

<cfoutput query="flowQy">
 <input name="depthinput#currentRow#" type="text" ... value="#somecolumninQuery#" id="depthinput#currentRow#" />
</cfoutput>

It's really hard to tell what your code is even attempting to do or exactly where the data is that you are trying to reference.

Upvotes: 1

Related Questions