RE: [CFCDev] Multiple results from a query passing into a bean

[Bill Sahlas]

Are you using stored procedures to get the multiple query results?  The CFSTOREDPROC tag combined with the CFPROCRESULT tag is useful when your dealing with multiple results sets. Each result set’s name is associated with the each individual query object returned by the stored proc and you get all the benefits that a cf query object has (sorting, extraction, concatenation, math operations, etc).   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stephen Adams Sent: Tuesday, September 13, 2005 9:13 AM To: cfcdev@cfczone.org Subject: [CFCDev] Multiple results from a query passing into a bean   HI, I'm having real trouble working out how to get multiple results from a query into a Bean to then pass to my display page. There's two ways I can think of doing this, one, create a Bean object for each row returned and passing the details of the row to that Bean. So I'd run my query the loop through the results and create a bean object at the top of the loop and use the Set methods of that bean to store the results. This sounds to me that there is a lot objects being created and this could slow everything down. The second way I can see to do this is to run the query then create a Bean object, which contains a array of struct's that hold the results of the query, then how do I get the results out of this array of structs to display in my pages? Are these two options possible or am I missing something fundamental here? Stephen ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to cfcdev@cfczone.org 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). CFCDev is supported by New Atlanta, makers of BlueDragon http://www.newatlanta.com/products/bluedragon/index.cfm An archive of the CFCDev list is available at www.mail-archive.com/cfcdev@cfczone.org