Power CMS Blog

I'm using PowerCMS to build a simple blog. Obviously I want the index page to include a listing of the most recent blogs. I wold like the listing to include the title and the first 70 words or so of the post. With the structure of the default cms tables how can I extract the blog title and the blog content to a single record, since they exist in separate records? I can use the ContentPagesetOrder field to tie the two together, but I've been unable to write a SELECT statement that will put them both in one record.

I need the recordset to include both the title and the content. How can I accomplish this??

See this tutorial for details:

http://www.webassist.com/tutorials/Create-new-pages-from-PowerCMS-templates

This post has been deleted.

I have two types of ContentRefID -- BlogPostTitle and Content. I also need to include the Content data in the recordset so t hat it is available as a separate field in the same record as the BlogPostTitle. The Results page just pulls the Title. . .

ETA: Think I got it --just modify the Detail page to show the limited Content. Getting the repeating region to work may be tricky. . .

ETA2: Repeating section works fine, if anyone is duplicating this. . .

Glad to hear you have it working.

Thanks -- another question.

I want to use the Results page to provide a listing of posts for a given month. I've altered the SQL to this:

SELECT C2.ContentGroup, C2.ContentPageSetOrder
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2 ON C2.ContentPagesetParentID = C1.ContentID
WHERE C1.ContentGroup = 'BlogPost' AND C1.ContentDate > d1 AND C1.ContentDate < d2
GROUP BY C2.ContentPageSetOrder
ORDER BY C2.ContentPageSetOrder DESC

adding the ContentDate parameters to the query. d1 and d2 are configured properly and available (returning 2013-04-01 00:00:00 and 2013-06-01 00:00:00 respectively to the results page), but the query doesn't filter the results.

Thoughts??

need more details. i don't see d1 and d2 defined anywhere, how are those defined?

I didn't post the variable declarations, but here they are

d1
Text
Default -1
$_GET['d1']

d2
Text
Default -1
$_GET['d2]

The variables display correctly on the Results page when echoed. . .

try using:

WHERE C2.ContentGroup = 'BlogPost' AND C2.ContentDate > d1 AND C2.ContentDate < d2

for the where clause

Still doesn't filter. . .

I have d1 and d2 set to a date earlier than the first ContentDate, and the results page still returns the first record in the db