Repeat Region Error

[dalgra]

Hi,
I'm trying to display a repeat region to display subcategories in one table to the left of the category image. When the repeat region is on left of the category image I get the following error:
Error Type:
ADODB.Field (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/rallymfg/2.asp, line 183

Now, if I put that table with the subcategory repeat region on the right of the category image, it works just fine.

I'll attach the code I have for the page, I called it "2.asp". By the way, the db is a simple access db.

I'll greatly appreciate anyone who could help me understand why this is happening, and letting me know what I need to do to be able to have the repeat region on the left of the category image and not get that error.

Thank you in advance,
Dan

[Newsgroup_User]

Are you using this recordset multiple times on the page? If yes, have you
tried resetting the recordset after it's first use?

You also have no body tag - is that included in the <header/includeset.asp?>
include file?

jon

[dalgra · Accepted solution]

Hi Crash,

As for the body tag, yes, it's in the <hader/includeset.asp>; I put all the header info. there for easy admin. purposes.
What I did is create a new recordset only getting the Category and the Category image and filtering the categoryID. That did the trick. You gave me a good thinking point.

Thanks!

[Newsgroup_User]

great! that was easier than i thought, hehehe.

"dalgra" <webforumsuser@macromedia.com> wrote in message
news:e4vl4u$1sg$1@forums.macromedia.com...
> Hi Crash,
>
> As for the body tag, yes, it's in the <hader/includeset.asp>; I put all
> the
> header info. there for easy admin. purposes.
> What I did is create a new recordset only getting the Category and the
> Category image and filtering the categoryID. That did the trick. You gave
> me a
> good thinking point.
>
> Thanks!
>