This, in some form, is pretty standard SQL database behavior. If one
allows NULL in a column, one must deal with it by checking and so on. You
might want to pick up a general SQL book or check out some of the
generally not very good ) tutorials on the net. You can define whether
NULL is allowed, and secondly ensure that non-NULL info is sent. In this
case, send a single blank, then you don't have to worry about DB specific
interpretation of "". Of course, you may prefer to not add anything if the
value is "" and accept the not found condition.
Joe Sam Shirah
Autumn Software
-----Original Message-----
From: Jason Puyleart <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Tuesday, August 24, 1999 5:29 PM
Subject: JDBC - Servlet problem
>Hi.
>
>This may be somewhat more JDBC orientated, but I was hoping that I could
>get some help.
>
>I am using Oracle 7 with the JDBC thin drivers.
>
>I have a servlet that updates/displays values from a table.
>The problem is that if I have an empty form value
>(a string initialized to ""), when I retrieve from the database I get
>a value of null.
>
>Is this correct? If so, how do I get an empty value into the database
>without returning null? Is NULL the same as the empty string?
>
>Thanks in advance!!
>
>Jason
>
>___________________________________________________________________________
>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
