Re: [Reactor for CF] Re: Iterator Quesion

Dan Vega Mon, 10 Jul 2006 10:13:48 -0700

Seems like it will work,only problem is that I use a custom tag for display tabular data and it needs a query, so my best bet may be to build the query and then pass it.

On 7/10/06, Works, Jonathan G. <[EMAIL PROTECTED]> wrote:

This is what I would do:

<cfset customerRecord = application.cs.getBean("CustomerRecord")>
<cfset customer = customerRecord.load(customerId=url.id )>

<cfset invoices = customer.getInvoiceIterator()>

<cfloop condition="#invoices.hasMore()#">

    <cfset currentInvoice = invoices.getNext() />

    

</cfloop>

Jonathan Works
Enterprise Application Architect
Bright House Networks
Advanced Broadband Services
Tampa Bay Division

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Dan Vega
Sent: Monday, July 10, 2006 12:52 PM
To: [email protected]
Subject: [Reactor for CF] Re: Iterator Quesion

Sorry, thats CustomerInvoice,Customer,Invoice. I am just making up an example to relate to my situation.

On 7/10/06, Dan Vega < [EMAIL PROTECTED]> wrote:

Let's say for example I have 3 tables. Product,Invoice,ProductInvoice and my reactor.xml looks like this.

        <object name="Customer">
            <hasMany name="Invoice">
                <link name="CustomerInvoice"/>
            </hasMany>
        </object>

        <object name="Invoice">
            <hasMany name="Customer">
                <link name="CustomerInvoice"/>
            </hasMany>
        </object>

        <object name="CustomerInvoice">
            <hasOne name="customer">
                <relate from="customerId" to="customerId"/>
            </hasOne>
            <hasOne name="Invoice">
                <relate from="invoiceId" to="invoiceId"/>
            </hasOne>
        </object>

If I am in my admin area and viewiing a customers invoices i can loop them using the following query

<cfset customerRecord = application.cs.getBean("CustomerRecord")>
<cfset customer = customerRecord.load(customerId=url.id)>

<cfset invoices = customer.getInvoiceIterator()._getQuery()>

So Up to there works fine, the question I have is, when I am looping the invoices query how do i find the related id's? In the CustomerInvoice table there is customerInvoiceID,customerId,invoiceId, I specifically need the customerInvoiceID each time I pass through the loop.

--
Dan Vega
[EMAIL PROTECTED]

--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --CONFIDENTIALITY NOTICE: This e-mail may contain information that is privileged, confidential or otherwise protected from disclosure. If you are not the intended recipient of this e-mail, please notify the sender immediately by return e-mail, purge it and do not disseminate or copy it.

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

--
Dan Vega
[EMAIL PROTECTED]
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[email protected]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Re: [Reactor for CF] Re: Iterator Quesion

Reply via email to