In reactor I created an iterator object that is lasily populated with a query of data.  I have a getQuery method that will simply return the query and a getArray method that will translate the rows in the query into objects.  Both those methods will let you get subsets of the data.  IE: getQuery(1, 10) will return 10 rows from row 1 (I think) as a query.  There's also a getAt() method to return an object from a specific point.

The nice thing is, under the covers, reactor doesn't create the objects based on the rows till you requst them. So, if you only use one object then only one is created.

Doug


On 5/30/06, Robert Munn <[EMAIL PROTECTED]> wrote:
I have used a struct of bean objects for the many stored in the one, but only where I know that the number of objects in the struct will be limited. For instance, I have a small content system I put together that stores property beans for content objects in a struct in the object bean. While a content object could in theory have an unlimited number of properties, I know in practice that any given content object will only have a handful of properties, so using a struct is ok.

On 5/24/06, Matt Williams < [EMAIL PROTECTED]> wrote:
I have a one to many relationship between two tables, or objects. I assume I should somehow store the many in the bean of the one.
What is your preferred way of handling this?

An Array of objects of the many?
A query of the table with the many?
A structure...?
Other?



--
---------------
Robert Munn
www.funkymojo.com ----------------------------------------------------------

You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone ( www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]



--
Doug Hughes
(Check out my Image Manipulation CFC at http://www.alagad.com) ----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to [email protected] with the words 'unsubscribe cfcdev' as the subject of the email.

CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting (www.cfxhosting.com).

An archive of the CFCDev list is available at www.mail-archive.com/[email protected]

Reply via email to