Hi
Keith, I already tried that code but it gives me
SQLException : No Data Found
I am using JSDK 2.1 and accessing MS-SQL Server Database....
Deepak
>From: Keith Ball <[EMAIL PROTECTED]>
>Reply-To: "A mailing list for discussion about Sun Microsystem's Java
> Servlet API Technology." <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>To : Deepak
>
>Hi.
>
>This bit of code works for me......
>
>
>String query = "SELECT * FROM MYTABLE" ;
>String verytempstring ;
>
>ResultSet rs = stmt.executeQuery(query) ;
>
>while (rs.next()) {
> verytempstring = rs.getString("REC_NAME") ;
> }
>
>if(verytempstring == null) {
> Do some bit of code if it equals NULL ;
> }
>
>
>Hope this helps...
>
>Keith
>
>---------------------------------------------------------------------------
>Keith Ball - Praktikant
>AF12 Operationelle Analysen Luftwaffe
>IABG MbH Einsteinstr. 20 85521 Ottobrunn
>Phone : 0049-89-6088-2556
>Email : [EMAIL PROTECTED] WWW site : www.iabg.de
>----------------------------------------------------------------------------
>
>----- Original Message -----
>From: Deepak Patil <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Friday, October 01, 1999 10:08 AM
>Subject: how to check whether a column value is null in a database table
>
>
> > Hi
> > I am using
> > rs.getString(1)
> > for getting a 1st columns value of a database table, I want to check
>whether
> > the value is null or not, because if I use it without checking whether
>it
>is
> > null or not it gives me a runtime NullPointerException....
> >
> > how can I check for nulity
> >
> > Deepak
> >
> > ______________________________________________________
> > Get Your Private, Free Email at http://www.hotmail.com
> >
> >
>___________________________________________________________________________
> > 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
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
___________________________________________________________________________
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
