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
