Hello All

I have a repeat region on my page which displays 10 records at a time, fine you would think but lets say there are 23 records, first diplay there are 10 on the page, user clicks "next" and the next 10 are displayed, fine, user clicks next again and it displays 3 records BUT then underneath where the next record would be if there was one, it comes up with an error saying it cant find the records, <b>either BOF or EOF is TRUE or record has been deleted</b>
How can I get it to stop once the last record has been reached?

Dave

Hi Dave,

It should just stop automatically when it's finished counting your records, as you most probably already know.
Have you been messing with the DB at all, changing tables, fields etc??
If it carries on i would create a fresh page with a 10 record repeat region and compare the code on the 2 pages.
Not a lot of help i know.

"Nobody ever said this stuff was easy"

does it show just the error or does it show a partial page with a error in it ?
if that's the case then you miss a record in a table that you JOIN in there... probably needs fixing manually at Dbase level (Backend as it's known in the IT sector).

Dennis

Thanks for the reply Dennis
It shows a partial page, up to the number of records that there are and then the error after that.

Dave

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
does it show just the error or does it show a partial page with a error in it ?
if that's the case then you miss a record in a table that you JOIN in there... probably needs fixing manually at Dbase level (Backend as it's known in the IT sector).

Dennis
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Thanks Davie

Will try creating another page and see what happens

Dave

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
Hi Dave,

It should just stop automatically when it's finished counting your records, as you most probably already know.
Have you been messing with the DB at all, changing tables, fields etc??
If it carries on i would create a fresh page with a 10 record repeat region and compare the code on the 2 pages.
Not a lot of help i know.

"Nobody ever said this stuff was easy"
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

I've sorted it, one of the dynamic fields was outside the repeat region, when it should have been in it.
works fine now.

Dave