I'm not an expert in this area but I think a Dao should generally be used to for a single record. If you want multiple records you use a Gateway instead.
One of the principal problems is that instantiating is cfc is a relatively expensive operation (when compared to doing the same in say c#). If you were to convert all returned rows in your recordset to an object, you'll really slow things down.
Stick to returning a query and if you really want to maintain the encapsulation look at wrapping your query using the iterator pattern.
Like I say, I'm no expert and hopefully if I'm wrong, I'm sure someone will let me know soon enough ;)
Cheers, Pete (aka lad4bear)
On 12/09/05, Stephen Adams <[EMAIL PROTECTED]> wrote:
Hi,
I'm trying to use a Bean and a DAO cfc's to access and return data from the database. My question in how do I use a Bean cfc with multiple results.
Do I create a separate page which creates the Bean and DAO objects, then calls the select method of the DAO cfc and then do I create a array of Bean objects, by looping overthe results, each holding the details of query results?
Is there any other ways to do this?
Stephen
----------------------------------------------------------
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).
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/[email protected]
----------------------------------------------------------
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).
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/[email protected]
