convert null into to null string

[DiggidyMack69]

I have a sql resultset called columns. When I convert an integer
column to string that is a NULL it converts to zero. How can I get it
to convert to null??

String x;
x = Integer.toString(columns.getInt("Integercolumnname "));

if x is null it will be converted to '0'. I want it converted to
null.

[Reinaerde]

If I understand you correctly it should be something like this:

String x = (null == columns.getInt("Integercolumnname"))
? null
: Integer.toString(columns.getInt("Integercolumnname "))
;

"DiggidyMack69" <Di***********@hotmail.com> wrote in message
news:c8*************************@posting.google.co m...

I have a sql resultset called columns. When I convert an integer
column to string that is a NULL it converts to zero. How can I get it
to convert to null??

String x;
x = Integer.toString(columns.getInt("Integercolumnname "));

if x is null it will be converted to '0'. I want it converted to
null.

[Nathan Zumwalt]

It looks like all your can do is test for null by using the
getObject("columnName") method. According to the JavaDoc, this will
return null if there isn't a value in the field. I'm surprised there
isn't an isNull("columnName") method.

-Nathan

Di***********@hotmail.com (DiggidyMack69) wrote in message news:<c8*************************@posting.google.c om>...

I have a sql resultset called columns. When I convert an integer
column to string that is a NULL it converts to zero. How can I get it
to convert to null??

String x;
x = Integer.toString(columns.getInt("Integercolumnname "));

if x is null it will be converted to '0'. I want it converted to
null.

[Reinaerde]

There is allways the wasNull() method call. If the converted value returns 0
this can allways be cahnged to some different value if the value 'wasNull'.
But unfortunatelly this value has to be fetched first :)

Rein

"Nathan Zumwalt" <na*****@hotmail.com> wrote in message
news:52**************************@posting.google.c om...

It looks like all your can do is test for null by using the
getObject("columnName") method. According to the JavaDoc, this will
return null if there isn't a value in the field. I'm surprised there
isn't an isNull("columnName") method.

-Nathan

Di***********@hotmail.com (DiggidyMack69) wrote in message

news:<c8*************************@posting.google.c om>...

I have a sql resultset called columns. When I convert an integer
column to string that is a NULL it converts to zero. How can I get it
to convert to null??

String x;
x = Integer.toString(columns.getInt("Integercolumnname "));

if x is null it will be converted to '0'. I want it converted to
null.

[DiggidyMack69]

"Reinaerde" <re*******@yahoo.com> wrote in message news:<3f***********************@news.xs4all.nl>...

If I understand you correctly it should be something like this:

String x = (null == columns.getInt("Integercolumnname"))
? null
: Integer.toString(columns.getInt("Integercolumnname "))
;

"DiggidyMack69" <Di***********@hotmail.com> wrote in message
news:c8*************************@posting.google.co m...

I have a sql resultset called columns. When I convert an integer
column to string that is a NULL it converts to zero. How can I get it
to convert to null??

String x;
x = Integer.toString(columns.getInt("Integercolumnname "));

if x is null it will be converted to '0'. I want it converted to
null.

Unfortunately if I do that the servlet won't compile. it tells me that
basically an int cannot be null. im going to play with the getObject
though.