Sheesh... 10 lines of code down to 2. Can't believe I didn't remember that.
THANKS! marc -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of jonah.blossom Sent: Saturday, April 21, 2007 5:32 PM To: [email protected] Subject: Re: [Reactor for CF] Getting a single object using getByFields() Hi Marc, Try: load(emailAddress = arguments.emailAddress) Marc wrote: > Hi Everyone, > > I'm totally brain-dead on this, and I bet the answer is simple... > > I am using ColdSpring/Reactor (with fusebox 3, but that doesn't matter). > > I have a PersonService.cfc that has a function, > getPersonByEmailAddress(String emailAddress). > > emailAddress is NOT the primary key in my Person database table. > > If, within getPersonByEmailAddress(), I use > personGateway.getByFields(emailAddress=arguments.emailAddress), as > expected I get back a query instead of an actual Person object. The > query has the person I'm testing with, so I know things are working up to that point. > > But I want my getPersonByEmailAddress() function to return a Person, > not a query. > > My thought was to therefore continue to use > personGateway.getByFields() to get the id, then create a newPerson > object (instance of Person) and then > load() it using the id returned in the getByFields query. > > But that seems ridiculous -- hitting the database twice to get a > person, just because I need to get the person by emailAddress instead of personId. > > What is the best way to do this? What have I forgotten about reactor > that lets me get a single object based on a field other than the primary key? > > Thanks, > > Marc > > > > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- > -- -- -- -- 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/ -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
