Thanks, Luke.
I was suspecting that such was the case. What I really want to do is
test for nulls in particular fields. I'll have a few more stabs at it
before I start looking for alternative solutions.
Henry
> Thanks, Luke.
>
> I was suspecting that such was the case. What I really want to do is
> test for nulls in particular fields. I'll have a few more stabs at it
> before I start looking for alternative solutions.
The code I posted *will* test for null on a particular column - the last
column referenced. OTOH, it would be easier just to test the returned String
value, because that will be null if the column is null. That's what I would
do in this situation. But that doesn't work for getInt or getLong, which
both return zero on null columns.
Luke
Henry - 27 Mar 2004 10:11 GMT
Cannot resolve symbol? Sure- since I was using "NULL" instead of
"null." The following does the job:
if(objRecordSet.getString("exer_time") == null)
out.println("<TD align='right'><FONT SIZE='-1' name='Arial'>" +
"-----" + "</FONT></TD>");
else
out.println("<TD align='right'><FONT SIZE='-1' name='Arial'>" +
objRecordSet.getString("exer_time") + "</FONT></TD>");
Chalk this up to an ODM malfunction - Oh Dopey Me.
Henry
>>Thanks, Luke.
>>
[quoted text clipped - 9 lines]
>
> Luke