Well, no, heh. There's no insert/update/delete for anything. But yes, if something like this is all you really needed (a few SQL statements) then by all means, knock it out!
On Mon, May 11, 2009 at 4:45 PM, Baz <[email protected]> wrote: > <cfparam name="url.PostID" default="0" /> > > <cfquery name="Posts" datasource="blog"> > SELECT Post.ID AS PostID, Post.Title, Post.Date, Post.Body, > Comment.Comment, Comment.Date, Comment.Name > FROM Post LEFT OUTER JOIN Comment ON Post.ID = Comment.PostID > > <cfif IsNumeric(url.PostID) AND url.PostID gt 0> > WHERE Post.ID = <cfqueryparam value="#url.PostID#" /> > </cfif> > > ORDER BY Post.Date DESC > </cfquery> > > <cfoutput query="Posts" group="PostID"> > <div id="Title">#Posts.Title#</div> > <div id="Body">#Posts.Body#</div> > > <cfoutput> > <div class="comment">#Posts.Comment#</div> > </cfoutput> > </cfoutput> > > There you go Brian, finished :) It only took 3 minutes, the OO version > would take me atleast 30 mins :-) :-) :-) :-) > > Baz > > > > On Mon, May 11, 2009 at 1:28 PM, Brian Kotek <[email protected]> wrote: > >> The main issue is the seemingly innocuous phrase "is going to stay that >> way". So if you're *really* sure it's going to stay that way, all is well. >> However, I'm not sure I've *ever* written an application that just stayed >> that way. Just something to be aware of. >> >> On Mon, May 11, 2009 at 4:12 PM, Baz <[email protected]> wrote: >> >>> If your blog is really that simple, and is going to stay that way, you >>> can write one or two queries, a couple of views and be done with it. >> >> >> I'd also say that unless one is really brand new to OO, the OO version of >> a blog isn't going to take anywhere near 10 times longer. In fact, with all >> the tools available at this point that facilitate some level of OO, or at >> least the use of CFCs, it will probably take much LESS time, assuming one is >> familiar with the tools (Transfer comes to mind). >> >> Just my two cents! :-) >> >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
