[Reactor for CF] How to reset getWhere() in an iterator ?

[Matt Hall-Smith]

Hello again,
 
Looking for guidance on the correct way to reset getWhere on an iterator ...
 
(On latest build via svn)
 
This (I think) should work, but my comments show that after the first
getWhere and a reset subsequent calls *append* the successive getWhere
statements causing q_AttrTwo and q_AttrThree to return zero records in the
3rd and 4th query.
 
<cfset r_Company = Reactor.CreateRecord("COMPANY").load(CompanyID=3854)>
  
<cfset q_iterator = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_iterator#"> <!--- 12 Attributes returned --->
 
<!--- attempt to get AttrOne -->
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',5)>
<cfset q_AttrOne = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_AttrOne#"> <!--- 1 Attribute returned, fires OK--->
 
<!--- reset backing query etc, and attempt to get AttrTwo-->
<cfset r_Company.getAttributeIterator().reset()>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',6)>
<cfset q_AttrTwo = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_AttrTwo#"> <!--- 0 records returned, should be 1 --->
 
<!--- reset backing query etc, and attempt to get AttrThree -->
<cfset r_Company.getAttributeIterator().reset()>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',4)>
<cfset q_AttrThree = r_Company.getAttributeIterator().getQuery()>  
<cfdump var="#q_AttrThree#"> <!--- 0 records returned, should be 1--->
 
This works (explicit resetwhere(), then 2 x GetWhere's to get where I want
to be) :
 
<cfset r_Company = Reactor.CreateRecord("COMPANY").load(CompanyID=3854)>
  
<cfset q_iterator = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_iterator#"> <!--- 12 Attributes returned --->

<cfset
r_Company.getAttributeIterator().getWhere().isEqual('CompanyAttribute','comp
anyID',3854)>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',5)>
<cfset q_AttrOne = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_AttrOne#"> <!--- 1 Attribute returned, fantastic --->
 
<cfset r_Company.getAttributeIterator().resetwhere()>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('CompanyAttribute','comp
anyID',3854)>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',6)>
<cfset q_AttrTwo = r_Company.getAttributeIterator().getQuery()>
<cfdump var="#q_AttrTwo#"> <!--- 1 Attribute returned, you beauty --->
 
<cfset r_Company.getAttributeIterator().resetwhere()>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('CompanyAttribute','comp
anyID',3854)>
<cfset
r_Company.getAttributeIterator().getWhere().isEqual('Attribute','AttributeTy
peID',4)>
<cfset q_AttrThree = r_Company.getAttributeIterator().getQuery()>  
<cfdump var="#q_AttrThree#"> <!--- 1 Attribute returned, hola --->
 
Should method 1 work or am I misiterpreting what reset() actually does ?
 
Cheers,
 
Matt
 
Pauaware Information Architects
 
Live data on demand
 
 
www.pauaware.co.nz <http://www.pauaware.co.nz/> 
 

 



-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --