close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Page from Template Summary Page

Thread began 10/17/2011 10:38 am by Daryl | Last modified 10/18/2011 4:08 pm by Jason Byrnes | 660 views | 5 replies |

DarylBeta Tester

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?

Sign in to reply to this post

Jason ByrnesWebAssist

  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.

Sign in to reply to this post

DarylBeta Tester

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.

Sign in to reply to this post

Jason ByrnesWebAssist

remove the group by clause:
GROUP BY C2.ContentPageSetOrder

Sign in to reply to this post

DarylBeta Tester

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...