<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
-~----------~----~----~----~------~----~------~--~---
