Try this...
<cfloop query="q">
<cfscript>
ArrayAppend(vleafnodes, q.account_id);
</cfscript>
</cfloop>
However this is not going to give you the ability to reference the array
element by the account ID, it sounds like what you want is a structure.
<cfloop query="q">
<cfscript>
StructInsert(myLeafStruct, q.account_id, q.account_id, true);
</cfscript>
</cfloop>
This will allow you to reference the account if by the query id.
Regards,
David McGraw
Oyova Software, LLC
http://www.oyova.com
> Hi All -
>
> I am trying to do the following in my code.
>
>
> <cfquery datasource="cfflex" name="q">
>
> SELECT
> t1.account_id
> FROM
> accounts1 AS t1
> LEFT JOIN accounts1 as t2
> ON t1.account_id = t2.parent_id WHERE t2.account_id IS NULL
> </cfquery>
>
> <cfset treeData = arrayNew(1) />
> <cfset vleafnodes = arrayNew(1) />
>
> <cfloop query="q">
> <cfset vleafnodes[q.account_id] = q.account_id>
> </cfloop>
>
>
> <cfquery name="getRec" datasource="cfflex">
> SELECT account_id, name, acc_num, debit, credit, balance, parent_id
> FROM
> accounts1 WHERE ...
> </cfquery>
>
> <cfloop query="getRec">
> <cfif getRec.account_id EQ vleafnodes[getRec.account_id]>
> <cfset vLeaf = true>
> <cfelse>
> <cfset vLeaf = false>
> </cfif>
>
> </cfloop>
>
> The array for the vleafnodes looks like below:
> array
> 1 [undefined array element] Element 1 is undefined in a Java object
> of type class coldfusion.runtime.Array.
> 2 [undefined array element] Element 2 is undefined in a Java object
> of type class coldfusion.runtime.Array.
> 3 3
> 4 4
> 5 [undefined array element] Element 5 is undefined in a Java object
> of type class coldfusion.runtime.Array.
> 6 6
> 7 7
> 8 8
>
> using isdefined or isarray to check if the element is defined in a
> particular position is not helping during the comparision statement
>
> <cfif getRec.account_id EQ vleafnodes[getRec.account_id]>
>
> I keep getting the following error
>
> Element 1 is undefined in a Java object of type class coldfusion.
> runtime.Array.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338043
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
