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
