[Reactor for CF] returnObjectField()

[Teddy Payne]

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
reactor@doughughes.net
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --