You'll need to use a struct to do your bidding instead of an array-- I don't
think you can skip values in arrays, so if your query is returning account_ids
1,2,4,5, #3 would fail.
maybe something like...
<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 = structNew() />
<cfset vleafnodes = arrayNew() />
<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">
<cfset vLeaf = false>
<cfif structKeyExists(vleafnodes, getRec.account_id)>
<cfset vLeaf = true>
</cfif>
</cfloop>
> 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:338045
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
