Don't have much hair left, this code gives me bof eof error.

Code:


var TestVal1 = ProductData.Fields("Category")
var TestVal2 = ProductData.Fields("Menu")
var Heading = ProductData.Fields("Category")
var Item = ProductData.Fields("Menu")

while(Heading== TestVal1)
{
TestVal2 = ProductData.Fields("Menu")
Response.Write("...
Response.Write("...

while(Item == TestVal2)
{
Item = ProductData.Fields("Menu")
TestVal1 = ProductData.Fields("Category")
if(Item == TestVal2)
{
ProductData.MoveNext
}
}
}

Example data:

Category Menu

All the Nuts Almonds
All the Nuts Boiled Peanuts
All the Nuts Boiled Peanuts
All the Nuts Candied Nuts
All the Nuts Candied Nuts
Other Delights Candy
Other Delights Candy
...

Any Ideas, not a connection problem! Data is there and sorted!