Yup, simple select * from a single table will cause it
Have run into the same problem using Joins though however.
I have also found that reassigning variables prior to a response.write will SOMETIMES work
eg:
Name=rs("Name")
...
<% response.write(Name) %>
' instead of <%...