You can create what's called a Gateway object that handles returning more than one record.
An interesting read on the subject: http://www.remotesynthesis.com/blog/index.cfm/2007/7/18/What-the-Heck-is-a-G ateway-Anyway > -----Original Message----- > From: Casey Dougall [mailto:[EMAIL PROTECTED] > Sent: Saturday, September 08, 2007 7:50 AM > To: CF-Talk > Subject: Using the component builder in eclipse > > Hi, > > When you use the component builder in eclipse published by > adobe, it creates a component with a bunch of geters and > setters, I can get and set one record at a time but I can't > figure out how to call these components so it gets multiple > records. I know the table has multiple entires for my criteria. > > <cfscript> > catObj = createObject("component", "includes.cfc.Category > ").init(IsActive=Val(1)); > catOut = StructNew(); > catOut.Category = catObj.getCategory(); </cfscript> > > This will return one record, how do I get all the records? > > > -- > Casey ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288053 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
