SELECT * FROM Customer where ListId = '710000-1197759579' or ParentRefListID = '710000-1197759579'

I usally expect to get back a couple of records for the parent and its children but sometimes I get no results back and I have not changed any of the data.

The query usally works the first time the page loads but subsequent loads do not produce any records. I have seen the same behavior from VBDemo.

Any ideas why the same query would sometimes produce results and at other time no results. The data has not changed between queries.

I used to have the same problem on my development machine, except then I would get the iterator error.