Custom query template – Page Navigation

Hi I have customised page templates which use customised queries – i.e. do not use the inbuilt have_posts etc. I have my own bit of sql per template.

Templates work I do have to limit the number of posts shown.

What I cant get to work is the page navigation, anyone got any ideas?

This is what i am affectively doing

$pageposts = $wpdb->get_results("select ....");
if ($pageposts):
foreach ($pageposts as $post) {
setup_postdata($post);
.....
....
}
endif

The issue is that as its customised, there is no way to tell page_next, page_prev about my query? Any workaround?