Hi,
isn't the following what you want?
int n = rs.getInt( 1 );
boolean b = rs.wasNull();
ron
--- Magnus Walter <[EMAIL PROTECTED]>
wrote:
> Change the SQL statement, configure the table to use
> default values, use
> some JavaScript to check the form values before
> submitting will all FIX the
> problem BUT !
>
> Can I check/handle NULL values in a recordset using
> JAVA (JDBC-ODBC) ?
>
> Example:
> I have a .jsp page for list all messages from table:
> tbl_msg (name
> varchar(50),title varchar(100),msg text). Column msg
> may include null
> values. If it find a null value in the msg column it
> will show nothing or do
> some spec. action like include another .jsp page
> .......
>
> Enviroment:
> Wint NT, MS SQL Server 7.0, Tomcat 3.1 ...
>
> So .... is it possible to check for null values in
> java, or handle null
> values before the error ?
>
> I'm very gratefull for all help !
>
> /Mange
>
> -----Ursprungligt meddelande-----
> Fr�n: Selvamani Jayakumar
> [SMTP:[EMAIL PROTECTED]]
> Skickat: den 14 augusti 2000 20:52
> Till: [EMAIL PROTECTED]
> �mne: Re: JDBC-ODBC and NULL
>
> hi
>
> you can change the SQL statement to avoid
> null. Check the fields
> which will be null and replace with space.
> You can use
> the NVL funct in Oracle and ISNULL funct in
> SQL Serv.
> By this way you can avoid null values before
> getString.
> It doesnt chnge your database values too.
>
>
>
>
>
> >From: Magnus Walter
> <[EMAIL PROTECTED]>
> >Reply-To: A mailing list about Java Server
> Pages specification and
> > reference <[EMAIL PROTECTED]>
> >To: [EMAIL PROTECTED]
> >Subject: JDBC-ODBC and NULL
> >Date: Mon, 14 Aug 2000 13:58:51 +0200
> >
> >Hi,
> >need help with JDBC-ODBC and NULL values ?
> >
> >When I use getString and the value is null
> I got a ugly ERROR ! Is
> it
> >possible to check for NULL values before i
> use getString ?
> >(getString will give me the error so the
> method wasNull() dont
> help)
> >
> >Please help !
> >( I dont want to change the database and
> its null values)
> >
> >/Mange
> >
>
>
>===========================================================================
> >To unsubscribe: mailto
> [EMAIL PROTECTED] with body: "signoff
> >JSP-INTEREST".
> >Some relevant FAQs on JSP/Servlets can be
> found at:
> >
> > http://java.sun.com/products/jsp/faq.html
> >
> http://www.esperanto.org.nz/jsp/jspfaq.html
> >
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> >
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
>
________________________________________________________________________
> Get Your Private, Free E-mail from MSN
> Hotmail at
> http://www.hotmail.com
>
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED]
> with body: "signoff
> JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be
> found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with
> body: "signoff JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
__________________________________________________
Do You Yahoo!?
Yahoo! Mail � Free email you can access from anywhere!
http://mail.yahoo.com/
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
