tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steve Ochani" <ocha...@ncc.edu>
Subject Re: Null
Date Thu, 21 Jun 2007 14:48:18 GMT
> options:
> define null as empty string  e.g.
> String null = "";

null is a reserved word in java, you can't redfine it.


> OR
> change compare to == ""
> 

??

if (null == rs.getString("col_foo"))
works just fine.

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/ResultSet.html#getString(int)

Returns:
    the column value; if the value is SQL NULL, the value returned is null 


> HTH
> M--
> This email message and any files transmitted with it contain
> confidential information intended only for the person(s) to whom this
> email message is addressed.  If you have received this email message
> in error, please notify the sender immediately by telephone or email
> and destroy the original message without making a copy.  Thank you.
> 
> ----- Original Message ----- 
> From: "Tim Funk" <funkman@joedog.org>
> To: "Tomcat Users List" <users@tomcat.apache.org>
> Sent: Thursday, June 21, 2007 7:24 AM
> Subject: Re: Null
> 
> 
> > The syntax below is correct. There must be something else
> > syntactically incorrect in your jsp causing your woes.
> >
> > -Tim
> >
> > Mohammed Zabin wrote:
> >> I tried it the other way, if( rs.getString("field") == null ) but
> >> the compiler plames that null can't be compared to string....
> >>
> >> On 6/21/07, Tim Funk <funkman@joedog.org> wrote:
> >>>
> >>>
> >>> if (null == rs.getString("col_foo")) {
> >>>    out.println("<td>&nbsp;</td>");
> >>> } else {
> >>>    // Evil since this doesn't escape the xml - for edutainment
> >>>    only out.println("<td>" + rs.getString("col_foo") + "</td>");
> >>> }
> >>>
> >>> -Tim
> >>>
> >>> Mohammed Zabin wrote:
> >>> > Hi All
> >>> >
> >>> > Anyone knows how to deal with null values in JDBC ResultSet??
> >>> >
> >>> > I am trying to render a table in jsp page that read its value
> >>> > from the database, sometimes, the database returns null values,
> >>> > and so, the
> >>> whole
> >>> > table couldn't be rendered. Is there any way to deal with null
> >>> > values.
> >>> >
> >
> > --------------------------------------------------------------------
> > - To start a new topic, e-mail: users@tomcat.apache.org To
> > unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org For
> > additional commands, e-mail: users-help@tomcat.apache.org
> >
> > 
> 
> 
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe,
> e-mail: users-unsubscribe@tomcat.apache.org For additional commands,
> e-mail: users-help@tomcat.apache.org
> 



---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message