It's getOrder() to get a reactor.query.order object doug
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of João Fernandes Sent: Monday, July 10, 2006 4:52 PM To: [email protected] Subject: RE: [Reactor for CF] Iterator Quesion I don't have reactor code right here but I think that Iterator object has a GetQueryObject() which is a reactor.query.query so you could <cfset customer.getInvoiceIterator().getQueryObject().setAsc("invoice","myfield").s etDesc("invoice","myotherfield")> <cfset invoices = customer.getInvoiceIterator().getQuery()> it should work, João Fernandes -----Original Message----- From: [EMAIL PROTECTED] on behalf of Beth Bowden Sent: Mon 10-Jul-06 9:35 PM To: [email protected] Subject: Re: [Reactor for CF] Iterator Quesion How would you set the order on this query? Thanks, Beth On 7/10/06, Doug Hughes <[EMAIL PROTECTED]> wrote: > > FYI, it's not _getQuery() as shown here: > > <cfset invoices = customer.getInvoiceIterator()._getQuery()> > > It's getQuery() as shown here: > > <cfset invoices = customer.getInvoiceIterator().getQuery()> > > Doug > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > Behalf Of Jared Rypka-Hauer > Sent: Monday, July 10, 2006 2:02 PM > To: [email protected] > Subject: Re: [Reactor for CF] Iterator Quesion > > Dan, > > You should be able to shorten your code here this way: > <cfset customer = > application.cs.getBean("CustomerRecord").load(customerId=url.id)> > > load() should return the record... unless this has changed > in the API. It hasn't *that I know of*. The way you have it > written now you end up with 2 customer records... > CustomerRecord and Customer. CustomerRecord is empty and > Customer has data... the former is an unneeded object. > > As far as getting the ID while you're looping... > > <cfloop query="invoices"> > <cfset ciID = invoices.customerInvoiceId> > </cfloop> > > Also, this bit here: > > <cfset invoices = > customer.getInvoiceIterator()._getQuery()> > > Should probably be: > > <cfset customerInvoices = > customer.getCustomerInvoiceIterator()._getQuery()> > > IIRC, the results from that call should be a join between > the Invoice table and the Customer table based on the > customerId in the current instance of Customer... you > should actually have 2 iterators as members in your > Customer object, one for Invoices and one for > CustomerInvoices, because of the hasMany linkages between > the various object tags. > > I may be wrong, and I'm working entirely from memory > here... but if I remember correctly that's how it SHOULD > work. > > Someone please correct me if I'm wrong? > > Laterz, > J > > On Mon, 10 Jul 2006 12:49:44 -0400 > "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] > > > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- -- -- -- -- > > Reactor for ColdFusion Mailing List > > [email protected] > > Archives at: > > http://www.mail-archive.com/reactor%40doughughes.net/ > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > > -- -- -- -- -- -- -- -- > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > Reactor for ColdFusion Mailing List > [email protected] > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- Reactor for ColdFusion Mailing List [email protected] Archives at: http://www.mail-archive.com/reactor%40doughughes.net/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
