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
