Hey nodevice,

I tried this code and had the same probs. I manaed to figure it out though..

In the ArticleHolder.ss change:
<a href="$NewsArticles.PrevLink"><< Prev</a> |
to:
<a href="$NewsArticles.PrevLink">&lt;&lt; Prev</a> |
And:
| <a href="$NewsArticles.NextLink">Next >></a>
to:
| <a href="$NewsArticles.NextLink">Next &gt;&gt;</a>

And in the ArticleHolder.php change:
$callerClass = "NewsArticle",
to:
$callerClass = "ArticlePage",

Minor changes, thanks for the code Matt. You might want to update the wiki.

Another point on this.. you may want to add in the order of the articles. This is probably obvious but for those which it isn't:

In change ArticleHolder.php change:
$sort = "",
to:
$sort = "Date DESC",

Then you'll get the latest article showing first.

Thanks a lot ScottiouS works fine now!!

I have found that with the order of articles displaying that if you have more than one article on the same day (date) and you are ordering by DATE then it will display the first one published at the top and the following ones below. To get past this I added ordering on the ID also. Although not optimal as ID's may be reused it does at least fix the problem in most cases.

So instead of just "Date DESC" put this in the SQL:

$sort = "Date DESC, `ArticlePage_Live`.ID DESC"

Or if your model is named `NewsArticle` then:

$sort = "Date DESC, `NewsArticle_Live`.ID DESC"

I have a probably stupid question:

why the use of ` in

$filter = "`ParentID` = '".$this->ID."'",

?

I believe the ` character (a backtick), is used to reserve names of tables and columns in a SQL query...

Cheers,
Sean

Sean's right - in MySQL at least, the backtick is used to differentiate MySQL keywords and table/column names. For example, ORDER is a MySQL keyword, but `ORDER` will make MySQL look for the 'ORDER' column.

It's handy when you have tables that uses columns such as 'order'.