How to get records 6-{n}, instead of "The First 5" or "All Records"

Fri, 25 Jun 2010 06:50:48 -0700

I have a site where I have a news page that displays the first 5 records of my News category. This works just fine.

Since I'm only displaying the first 5 records on the main news page (the client doesn't enter many news items over time), I've also created a News Archive page. On the News Archive page I'd like to display all news records after record 5 - so, records 6 thru {total records}. This way, the client doesn't need to move records from News to a "News Archives" category in the CMS. They can just keep entering news and records will roll off the main news page and be displayed on the News Archive page if they are the 6th record or greater.

Is there a customer MySQL query or something that I should use on the News Archive page to pull news records, starting at the 6th record?

Thanks in advance for your help. I've been using your products for years, and I love the new CMS Builder!

Re: [ross] Incorrect datetime value

Thu, 24 Jun 2010 16:11:53 -0700

Did this ever get resolved? I just installed the latest version of CMS builder and I'm getting the following error:

MySQL Error: Incorrect datetime value: '2010-06-31 20:45:00' for column 'event_date_and_time' at row 1

All I did was set up a date/time field using the built-in options, so I'm not sure what would be causing this.

Help - please [:(]

How do I post a single item to multiple sections and merge section listings into one sorted list?

Wed, 16 Dec 2009 08:48:31 -0800

I'd like to:

- Post a single item in a section and have it appear in a list for multiple sections

- Merge lists from multiple sections into a single, sorted list

For instance, I'd like to be able to publish a news pieces in multiple sections, then merge the news pieces from those multiple sections into a single list on the home page of a website (as sort of an über feed).

Also, any way to do this and automatically generate an xml feed?

If you have plugins for CMS Builder or related posts in this forum that you're aware of please feel free to reference those as well.

Thanks in advance,

Aaron

Re: [Donna] Adding article to more than one category breaks Placeholder Set Name in list of articles template

Mon, 02 Nov 2009 04:48:35 -0800

Just wanted to follow up with a post showing the interactivetools.com support response that ultimately solved my problem:

.......

The way Article Manager handles multiple-category articles is by assigning a "primary" category. In all of the articles that are being published without the link, the "primary" category is: The Buzz : The Buzz - The Latest News

So... Article Manager is trying to link to the article created for that category. But that article doesn't exist with that publish rule, and so it comes back with nothing.

To test this out, I added "The Buzz" category mentioned to the "Latest News Detail Pages (BA)" publish rule, and republished both the articles & the associated index, and the links now work.

Basically, make sure that your publish rule is publishing for the primary category set, and you shouldn't run into this.

......

Re: [Donna] Adding article to more than one category breaks Placeholder Set Name in list of articles template

Fri, 23 Oct 2009 04:52:45 -0700

Correct, I have the following:

$article.title$

I added the "ba" suffix to differentiate this from the other template which uses:

$article.title$

Any other thoughts?

I'll email you credentials for logging into our installation of Article Manager so you can get any details you need to troubleshoot this.

Thanks so much for being so prompt. I'm hoping to finish up some development this weekend and this is a stumbling block.

I've purchased many Article Manager licenses and, more recently, CMS Builder licenses, and I love your products.

Aaron

Re: [zakcoop] Adding article to more than one category breaks Placeholder Set Name in list of articles template

Tue, 20 Oct 2009 20:06:44 -0700

Since only the unique "_suffix" is being published for items in the 2nd list of article publishing rule, it seems like the isn't getting populated in the second list of articles publishing rule.

I'm using "_ba" as the suffix (see screenshot). Am I declaring this "Published Files" name incorrectly? Only the "_ba" suffix is getting published in the URL.

Adding article to more than one category breaks Placeholder Set Name in list of articles template

Tue, 20 Oct 2009 19:54:31 -0700

Here's what I've done:

- Created 2 categories
- Created 1 article
- Assigned this 1 article to each of the 2 categories I created
- Created 2 "a page for each article" publishing rules - each with a unique "Placeholder Set Name", unique Filename (eg: "" AND "_suffix") and assigned to each of the 2 categories via the 'Category Filter' control
- Created 2 "a list of articles" publishing rules - each with a unique "Placeholder Set Name", unique Filename and assigned to each of the 2 categories via the 'Category Filter' control

So, I end up with the 1 article I created being published 2 times (eg: "articlenameForCat1" and "articlenameForCat2"). This is good.

I also end up 2 published article lists - one for each "as list of articles" rules. This is also good.

The problem is that one of the published article lists has the correct URL for each article, but the 2nd published article list does not.

What seems to be happening is that when I assign an article to 2 categories, only the first category I assign it to is honored. In the 2nd published article list, the URL for each article only includes the "_suffix" in the URL, not the "_suffix".

For instance, the 1 article that I created might have a filename as:

article_one

This would mean that, based on my publishing rules, the URL should be as follows for the 1st and 2nd published article lists, respectively:

article_one
article_one_suffix

However, this article shows up in the 1st published article list with a URL of:

article_one.html (this is a good thing)

...but in the 2nd published article list is has a URL of:

_suffix.html (this is a bad thing)

For some reason, only the first list of articles publishing rule is fully publishing the URL.

I'm doing this because I'm redesigning a site and want to keep the main articles in tact, but assign them to 2 categories - 1 which is the category within the existing site and the other category which exists for the newly designed site. This way, I can keep the content in tact and just pull new includes into the new site without effecting the existing site (essentially, using this for staging).

Please help!

Thanks,

Aaron

Error when uploading multiple images

Fri, 16 Feb 2007 08:40:49 -0800

When I try to upload up to 10 images, I get the following error:

Error: Couldn't find end of field header! at (eval 56) line 11, line 527.

This doesn't occur if I try to upload fewer than 10 images at a time (e.g. if I do only 5 everything goes smoothly).

This occurs in Firefox.

Any thoughts?