> Thanks Aaron we tried that and got the same result.
> This is what our code is doing...
> if "something" then
> set rs = "SQL stmt"
> end if
> then we use the rs here.
> ... our problem is that when "something" is true, we're
> not getting to the other page. It seems to want to finish
> loading the current page and we get the error when we use
> the rs further down in the code. Again, this is working
> on IIS4/NT and not IIS5/Win2k.
> >-----Original Message-----
> >> 315 --> If rs.EOF or rs.BOF Then
> >Once you figure out that earlier in the code, you used
> set rst =
> >conn.execute("some query") or set rst = createobject
> ("ADODB.Recordset"), you
> >can remove the test for BOF. BOF is where you start in a
> perfectly valid
> >result, so if rs.eof is false, and there is a valid
> resultset, BOF will be
> >true, and this logic will still be entered. I think you
> meant to check:
> >if not rs.eof then
> > ' there is a valid result, loop through!
> > STRSHOP = STRSHOP & 0 & ")"
> >end if