«

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

On Oct 31, 10:38*am, Devin <devin.corm...@gmail.com> wrote:
> 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

It was unrelated. This post can be deleted

Devin wrote:
> On Oct 31, 10:38 am, Devin <devin.corm...@gmail.com> wrote:
>> Hi,
>> I'm getting an exception error on this line:
>>
>> do while not rs.eof and ucase(rs.fields("category")) =
>> ucase(holdLast)

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

Devin wrote:
> Hi,
> I'm getting an exception error on this line:
>
> do while not rs.eof and ucase(rs.fields("category")) =
> ucase(holdLast)
>
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