Unexpected Exception.

Hi,
I'm getting an exception error on this line:

do while not rs.eof and ucase(rs.fields("category")) =
ucase(holdLast)


This error occurs on the last record in the table (mdb). I deleted
the last few records from the table to see if it was something with
the record. The same thing occured.


I also response.write the values of rs.fields("category") and
holdLast and they output the values I would expect.


Am I going nuts?

I don't want to post my enter page, but if the error could really go
beyond this line then please let me know.

Thanks for any input.


DC

re: Unexpected Exception.

On Oct 31, 10:38*am, Devin <devin.corm...@gmail.comwrote:It was unrelated. This post can be deleted :)

re: Unexpected Exception.

Devin wrote:Both expressions are evaluated. If EOF is true, then
rs.fields("category") will raise an error.
Change it to:
do while not rs.eof
if ucase(rs.fields("category")) =ucase(holdLast) then
end if
rs.movenext
loop




--
HTH,
Bob Barrows

re: Unexpected Exception.

Devin wrote:Oops, I should have written:

do while not rs.eof
if ucase(rs.fields("category")) =ucase(holdLast) then
...
else
break
end if
rs.movenext
loop


--
HTH,
Bob Barrows