Re: [kapelle] searching & tagged content on index page

Thu, 18 Sep 2008 23:20:59 -0700

LOL I have no idea what I'm doing, but it looks like I fixed it. I changed:

where => " DATE_FORMAT(date, '%Y-%m-%d') = '2008-09-16' ",

to:

'where' => " DATE_FORMAT(date, '%Y-%m-%d') = '2008-09-16' ",

I just put the single quotes around WHERE because the error message said assumed 'where'

Re: [Dave] searching & tagged content on index page

Thu, 18 Sep 2008 23:10:16 -0700

Thanks! It works, but I also get this error message:

Notice: Use of undefined constant where - assumed 'where' in /home/content/h/e/a/hearts2god/html/WorshipMax/index.php on line 94

Re: [Dave] searching & tagged content on index page

Wed, 17 Sep 2008 22:35:30 -0700

I don't want to bring up dates by category, I want to bring up dates under the entire section editor table. This is what i have now and it's working, but not what I want:

require_once "/home/content/h/e/a/hearts2god/html/cmsAdmin/lib/viewer_functions.php";

list($resourcesRecords, $resourcesMetaData) = getRecords(array(
'tableName' => 'resources',

where => " category = 'music' AND DATE_FORMAT(date, '%Y-%m-%d') = '2008-09-16' ",

so, I don't want articles dated the 16th from JUST music, I want all the articles in the tableName resources. How would I write that?

Re: [Dave] separating categories

Mon, 15 Sep 2008 11:25:52 -0700

I'm not sure what you mean by "pulldown."

Instead of having Multi Record section editors for each topic, I have them all listed in one Category Menu section editor called "resources."

music, software and links are all under "resources" as parent categories, and I assign articles to these parent categories.

Are you saying I should create a Multi Record section editor (not a Category Menu) and add a list field, display as pulldown, create music, software and links list options, then tag my articles using this pulldown?

separating categories

Mon, 15 Sep 2008 01:46:42 -0700

Hi, I have three parent categories:

music
software
links

I have a bunch of articles on the different topics, and have assigned the topics to a parent category (articles about "music" have been assigned to the "music" parent category.

I've grouped these all together in one section editor category so I can have all the articles for a specific date appear on my homepage. - and you all helped me with this on another post.

My question now is, Is there a way to separate the categories?

Would I have music.php, software.php and links.php pages? All the music articles would be on the music.php page, etc.

Re: [Dave] searching & tagged content on index page

Mon, 08 Sep 2008 19:40:22 -0700

thanks! I got the search working.

So, instead of having separate section editors for the different subjects like I normally do, I'll have all the different subjects in ONE section editor as separate categories? With different articles under these separate categories?

If that's the case, what code would I use to put separate categories on separate pages? - instead of Admin > Code Generator > select section as I normally put each section editor on a different page, how do I now put the different categories on separate pages?

If this is the only way to do it, no problem. But for me it would be easier to do it the regular way of separate section editors (it would be easier I think to keep track of all the content instead of having all the items listed under one category)

To make sure I understand, there's no way to pull all the articles with the same date from all the section editors in the database and put them on the index page in a "what's new" section? I'll have to go the route of putting them all in one category section editor?

Re: [Michael Blake] searching & tagged content on index page

Mon, 08 Sep 2008 16:36:13 -0700

Would there be a way to just put a date, like "september 2" in the code, and then it would show all the articles on the index page, no matter which section editor they're in?. I will have a date field, and the code would pull up all the articles that have the date.

I would leave the same code in the index page, but just change "september 2" to the next week's date, pulling new articles into my "what's new" section.

The only problem is I know nothing of coding so could somebody show me what to put and where to put it - I'm great at cut and paste [:)]

Re: [Jake] searching & tagged content on index page

Mon, 08 Sep 2008 00:47:17 -0700

I'd like to show the articles no matter what section they were posted to - so if I posted articles this week on Tuesday, Sept. 9 in several section editors, I would have only these articles show up in the "what's new" section on the index page. Then, the next week I'd change the code on the index page to only show the articles posted on Tuesday, Sept. 16, etc.

I know there's the feature to show only the last few articles, or the latest articles, but I don't want that. I'll have a date field and want to be able to say "I only want the article's title and summary from Sept. 9, from anywhere on the website, to show up on the index page" and there would be a link to the article wherever it is on the website.

searching & tagged content on index page

Fri, 05 Sep 2008 21:24:40 -0700

Hi, here's my setup. I posted a question a few days ago but have decided to go in a different direction and have 2 questions. I have several section editors:

news
articles on music
articles on websites
articles on songwriting
articles on sound equipment
website links
tutorials

1. Is it possible to do a search on the entire website and display the results, or can you only search one section editor at a time?

2. Each section will have several articles, with new content added each week. Let's say I put a new article in each section on a Monday. Is it possible to tag all the articles by date, then have only the articles from every section tagged by the same date (Monday) appear on the index page, like in a "what's new" section?

Marked items from separate sections appearing on index page

Tue, 02 Sep 2008 00:23:16 -0700

Hi, I just got CMS a few days ago and almost have it ready to go, and I have a question:

I have several section editors, each with their own page:

news
articles on music
articles on websites
articles on songwriting
articles on sound equipment
website links
tutorials
(plus several more)

Each section will have new content every Tuesday.

What I'd like to do is assign every item in every section a date, then be able to put all the items for a specific date on the index page. Is that possible?

So, on the index page will be a "what's new section" and only the items that are tagged with, let's say, "September 2" will show up on the index page. Then, all the new content as well as the old content will all be listed also on the section editor page.

Would I need to put a viewer for each section on the index page? Or would there be a way to group several sections together under a single category, then put a viewer for that category on the index page?

For example, instead of having a separate viewer for each of the article section editors, could I group all the articles under a category, then have a single viewer that would only post articles dated "September 2?"