Hi,
You can use the method getString() to get the value as a string.
If the string is null/of zero length the value was a null, otherwise you can
parse it to get the actual value.
Gokul
----- Original Message -----
From: "William Crawford" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, August 04, 2000 12:56 AM
Subject: Re: Problem with using getInt??...Please Advice!
> Take a look at the JDBC API specification, which discusses the behavior of
> getInt() and associated methods. Consider that there is no way for an int
> primitive to have a blank (i.e. null) value.
>
> You can use getObject() instead, which will return a java.lang.Integer
> (probably, but it depends a bit on the driver) if there is an actual
value,
> and null if there isn't. Alternately, you can call the wasNull() method to
> see if the last value read was null.
>
> There are a number of good JDBC tutorials on the web and in various
servlet
> books.
>
>
> At 11:47 AM 8/3/2000 -0700, you wrote:
> >When I do the following:
> >
> >SQL> select ftrnr from scars.str where strnr=45678;
> >
> >I got:
> >
> >FTRNR
> >----------
> >
> >which is correct. FTRNR column has no value.
> >
> >FTRNR column in the database table is defined as NUMBER(6)
> >
> >However, when I am writing the code to retrieve the value of FTRNR I
always
> >get a "0" value.
> >This is false; the value should be blank. How do I fix this problem?
> >Because for some
> >FTRNR, the value in the database is actually "0" and not blank.
> >
> >Ps: I am having this problem because in my code I also have to make a
> >decision to display the
> > FTRNR in the report. And some value of FTRNR is "0" and others
are
> >blank or null.
> >
> >Here is my code:
> >
> >
> > String sel_ftrnr = "SELECT ftrnr from scars.str where strnr=45678;
> > rs = stmt.executeQuery(sel_ftrnr);
> > while(rs.next()) {
> > int ftrnr_value = rs.getInt("ftrnr");
> > }
> >
> >
> >Thank you for your help in advance.
> >
>
>___________________________________________________________________________
> >To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> >of the message "signoff SERVLET-INTEREST".
> >
> >Archives: http://archives.java.sun.com/archives/servlet-interest.html
> >Resources: http://java.sun.com/products/servlet/external-resources.html
> >LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
> ---
> William Crawford + 01 617 577 7844
> Invantage, Inc
[EMAIL PROTECTED]
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
