Evaluate function

Question

Is there a better way to write the following?

<cfloop list="#qry.Columnlist#" index="FieldName">
   <cfset "form.#FieldName#" = Evaluate("qry.#FieldName#")>
</cfloop>

This loop is assigning every field in the query to a corresponding form field. I understand the evaluate function is shunned.

score 11 · Accepted Answer · answered Jan 06 '10 at 19:35

11

<cfloop list="#qry.Columnlist#" index="FieldName">
    <cfset form[FieldName] = qry[FieldName][1]>
</cfloop>

?

answered Jan 06 '10 at 19:35

Henry

32,689
19
120
221

1

Good answer! I was looking for a solution to this today too. – Dan Sorensen Jan 07 '10 at 17:20
What about `evaluate("qry.#myArr[i].foo#")` I tried `qry[myArr[i][foo]]` but no luck – isurfbecause Oct 26 '12 at 00:32
@isurfbecause not sure what u're asking there, but for array object, it's `[fieldName][rowIndex]`. Is `foo` the rowIndex? if so, set `myArr[1]` to some var first, then use that. CF might not like nested `[]` – Henry Oct 26 '12 at 01:13
myArr is an array of structs, so foo is an attribute in the struct. – isurfbecause Oct 26 '12 at 15:25

score 4 · Answer 2 · answered Jan 06 '10 at 19:25

4

Assuming you are returning a single recordset the following will work.

<cfloop list="#qry.Columnlist#" index="FieldName">
<cfset "form.#FieldName#" = qry[FieldName][1]>
</cfloop>

answered Jan 06 '10 at 19:25

jarofclay

680
4
12

1

Technically, there is nothing wrong with that. But you may as well go the whole way and use array notation for both sides of the cfset ;) – Leigh Jan 06 '10 at 20:30

score 1 · Answer 3 · answered Jan 14 '10 at 14:52

1

Tangential, but if you were looping over multiple rows of a query, you could use the currentRow variable in the query object to do the same thing as the accepted answer.

<cfset var someStruct = {} />
<cfset var colummnList = queryObj.columnList />

<cfloop query="queryObj">
    <cfset someStruct[currentRow] = {} />        

    <cfloop list="#columnList#" index="fieldName">
        <cfset someStruct[currentRow][fieldName] = queryObj[fieldName][currentRow] />
    </cfloop>
</cfloop>

answered Jan 14 '10 at 14:52

Bialecki

30,061
36
87
109

Very interesting. I'm getting confused mixing struct notation and array notation, but I'll look into this. Thanks! – Phillip Senn Jan 14 '10 at 15:39
Yah sorry, {} is shorthand for StructNew() and [] is shorthand for ArrayNew(1) – Bialecki Jan 14 '10 at 18:28

Evaluate function

3 Answers3

Linked