This isn’t a bad suggestion.  Can you add it to the trac.reactorframework.cm bug tracker as a feature request?

 

Thanks!

 

Doug

 


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Teddy Payne
Sent: Sunday, June 04, 2006 8:38 PM
To: [email protected]
Subject: [Reactor for CF] returnObjectField()

 

Premise:

query = Suppliers.CreateQuery();
where = query.getWhere();

query.returnObjectField("Suppliers","Address");
query.returnObjectField("Suppliers","City");

where.IsLike("Suppliers","Country","G","left").setMode("and").addWhere(where.CreateWhere().IsEqual("Suppliers","PostalCode","60439"));

Questions:

Is there a way to shorten the way to return the object fields of a query?

I noticed that there is a method for returnObjectField, which sets the one return object at time to the query.

query.returnObjectField("Suppliers","Address").returnObjectField("Suppliers","City"); works to sort of simplify returned objects.

Is there another method that I am missing that allows for selecting multiple columns in one statement without compounding the method call?

I noticed that there is a method called returnObjectFields which is the plural version.  I tried query.returnObjectFields("Suppliers","Address,City"); and the query returned all columns.

Am I implementing this incorrectly?

--
<cf payne />
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
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/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --

Reply via email to