Could you send rest of your code.
Your ResultSet could be a null (depending how did you get the ResultSet).

Anyway, try to check ResultSet for null:
if(ResultSet != null)
{
    String PrdDesc = ResultSet.getString("PrdDesc");
    // rest of the code
}


----- Original Message -----
From: Bean <bean_00@h...>
To: Pro_JavaServer_Pages <pro_jsp@p...>
Sent: Sunday, January 14, 2001 6:36 PM
Subject: [pro_jsp] RE: How to catch Memo type variable if it is null?


> Dear Bob Good ,
>
> the jsp generate a error page when ever ResultSet.getString("PrdDesc") is
a
> null, so it will stop at
> >   String PrdDesc = ResultSet.getString("PrdDesc");
>
> and can't proceed furture, and both .length() !=0 , != null just can't
work
> with Memo type , I have no idea why is it like that
>
> ----- Original Message -----
> From: "Bob Good" <goodsys@h...>
> To: "Pro_JavaServer_Pages" <pro_jsp@p...>
> Sent: Saturday, January 13, 2001 4:33 AM
> Subject: [pro_jsp] RE: How to catch Memo type variable if it is null?
>
>
> > Maybe this would work
> >   String PrdDesc = ResultSet.getString("PrdDesc");
> >   if (PrdDesc == null)
> >               PrdDesc = "";
> >
> > Question: is the field defined as NOT NULL in the database?
> >
> > Bob