The weblogtoolscollection tutorial above shows all articles on the site, from all categories, with paging on a specific Page, but doesn't allow you to specify the articles to come from a specific category. You can get the same result on the homepage.
On NerdGrind we needed a Page that would show all articles from a specific category, or multiple specific categories, not all categories, and for those articles to be paged on the Page. You can see the result using the link below.
I posted the code above when this thread started, but I had to slightly modify it to work with the latest version of WordPress. The code that changed was is_archive to is_category. The working code is shown below:
// set $more to 0 in order to only get the first part of the post
$more = 0;
$limit = get_option('posts_per_page');
$paged = (get_query_var('paged')) ? get_query_var('paged') : 1;
query_posts('cat=12&showposts=' . $limit=5 . '&paged=' . $paged);
$wp_query->is_category = true; $wp_query->is_home = false;
<?php while (have_posts()) : the_post(); ?>
On NerdGrind we plan to start doing WordPress tutorials soon which will be found in the http://www.nerdgrind.com/latest-how-tos/ section.