Page from Template Summary Page

I would like to create a page that shows an image, title and a paragraph from each page that was created based on a template.

The problem that I am having is making a recordset that I can use to make a repeat region with that pulls the relevant data from the database.

I have tried to use the dynamic menu SQL example on the Power CMS forum with little success.

Is this possible?

  I have tried to use the dynamic menu SQL example on the Power CMS forum with little success.  

I assume from this you mean the following SQL:

SELECT C2.ContentGroup, C2.ContentPageSetOrder
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2 
ON C2.ContentPagesetParentID = C1.ContentID 
WHERE  C2.ContentPageSetOrder IS NOT NULL 
GROUP BY C2.ContentPageSetOrder 
ORDER BY C2.ContentPageSetOrder DESC

for your needs, you will probably need to modify the select statement to include the contentValue and ContentPageName columns as well:

SELECT C2.ContentGroup, C2.ContentPageSetOrder, C2.ContentValue, C2. ContentPageName
FROM pcms2_contents AS C1 LEFT OUTER JOIN pcms2_contents AS C2 
ON C2.ContentPagesetParentID = C1.ContentID 
WHERE  C2.ContentPageSetOrder IS NOT NULL 
GROUP BY C2.ContentPageSetOrder 
ORDER BY C2.ContentPageSetOrder DESC

if that is not working for you, please describe the results you are getting using that SQL versus the results you are expecting so i can have a better idea of the problem.

Hi Jason

Thanks for your help.

Unfortunately that query only returns one of the records that relates to the templated page. There are a total of 6 content areas that relate to each templated page.

remove the group by clause:
GROUP BY C2.ContentPageSetOrder

Thats great, but how do I now select which of those records that I want to display on my page?

All 6 content areas are now listed in the recordset, but I would need to display the 3rd 4th and 6th content are in certain places ie.

one is a title, one is an image and one is a paragraph of text...

you would need to hand code logic to loop through the recordset and return the correct record, this is not code I can really offer support for though. If you need more assistance with this, i would recommend signing up for a Prier ticket where we could work with you in a one on one scenario.