Sorry about the misleading subject line. This is more about beans than the iterator that I mentioned.
Alan ________________________________________ From: [email protected] [EMAIL PROTECTED] On Behalf Of Alan Livie [EMAIL PROTECTED] Sent: 05 July 2008 10:46 To: [email protected] Subject: [CFCDEV] Iterators / IBO's I'm an occasional user of iterators. I have a query that involved joins on several tables because data from those tables is needed inside the <cfoutput query in the View. Logic started creeping into the View as the query was looped. ie <cfoutput query="qGetXXX"> <cfif qGetXXX.thisBoolCol> <cfset valueToDisplay = qGetXXX.aNumericCol * qGetXXX.anotherNumericCol> <cfelse> <cfset valueToDisplay = qGetXXX.aNumericCol + 1 /> </cfif> </cfoutput> I want to use the Iterator so the logic is taken out the view but I get the performance benefit of query instead of bean array. My question is about the complexity of the bean and apologies if it isn't the best explanation I give! The data returned in the query is from several tables but only one or two columns may be used. I have simple beans for most of the tables involved in the joins. Should I a) Create a complex bean with associations to the other beans ie beanA has its own properties but is composed of a BeanB and BeanC even though I only need one property out of BeanB and 2 from BeanC. b) create a new bean specific to what the page / query is doing ie have a BeanD with properties of all the display data I need where I can still use getters to provide the encapsulation I need. My thinking is a) is a more elegant solution and more reusable but I need to do more work to build the bean in my bean factory and also bring more data out of the db and b) is quicker, leaner but I have little chance of reusing it elsewhere in the app. Any thoughts? Especially from users of Iterators / IBO's Alan ________________________________________ From: [email protected] [EMAIL PROTECTED] On Behalf Of Rob Brooks-Bilson [EMAIL PROTECTED] Sent: 03 July 2008 22:47 To: CFCDev Subject: [CFCDEV] Re: Porn galleries and hardcore adult pics in many categories. Guys, if this keeps up, I'll turn on moderation. For now, it seems like this is an isolated occurrence on this list, no? -Rob On Jun 24, 8:42 am, "Stephen Moretti" <[EMAIL PROTECTED]> wrote: > I just changed the Scottish CFUG google group to moderate new members... > :( Sad times. > > 2008/6/24 Brian Kotek <[EMAIL PROTECTED]>: > > > > > If someone posts a message with the word porn in it, I'd say just ban them > > immediately. This is becoming common on all of the unmoderated Google lists. > > > On Tue, Jun 24, 2008 at 7:52 AM, Mark Drew <[EMAIL PROTECTED]> wrote: > > >> I thought this was a discussion like "How to do high load image > >> serving applications in CF" > > >> But I guess its just spam. > > >> Time to ban this fella? > > >> MD > > >> On Tue, Jun 24, 2008 at 12:47 PM, geourgious <[EMAIL PROTECTED]> wrote: > > >> > Porn galleries and hardcore adult pics in many categories. > > >> > ... Sex .... > > >> -- > >> Mark Drew > >> Blog:http://www.markdrew.co.uk/blog/ > >> LinkedIn:http://www.linkedin.com/in/mdrew > > -- > Stephen Moretti > Blog :http://nil.checksite.co.uk/ > Twitter :http://twitter.com/mr_nil --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CFCDev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfcdev?hl=en -~----------~----~----~----~------~----~------~--~---
