Just plain weird..

[E3]

Do Until RSCategory("parent_cat&quot = "Top"
TempPath = &quot;<A HREF=&quot;&quot;&quot; & PathToPage _
& &quot;?CategoryName&quot; & RSCategory(&quot;parent_cat&quot & &quot;&quot;&quot;>&quot; _
& RSCategory(&quot;parent_cat&quot & &quot;<A> > &quot; & TempPath
Set RSCategory = Conn.Execute(&quot;Select parent_cat from &quot; _
& &quot;Categories where cat_name = '&quot; _
& RSCategory(&quot;parent_cat&quot & &quot;'&quot
Loop

cat_id   cat_name   parent_cat

1   Sega Nights Pad   Saturn
2   Playstation Controller   PlayStation
3   PC   Top
4   Software   PC



Error: Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/Auction_List.asp, line 20

 

[link9]

you've moved past the end of your recordset.

try using:

do until RSCategory.eof

as your loop control

 

[E3]

eh?

a friend of mine is using access and shes able to get it working. But I m using MSSQL

Basically I m using TOP as my eof element. And I can't think of anyway to change the loop. Oh no..

 

[E3]

Problem solved.
I had some typing mistakes that cause this.