NULL value problem (URGENT please!)
Posted on 2003-12-04
From my JSP program I need to execute an SQL insert statement:
...//some work done on st1
count = stmt.executeUpdate("insert into mytab (f1, f2,..) values ('st1', ...,..)");
Here when I execute above statement, I do not know if string "st1" has some value or if it is null. If "st1" has some value, no problem.But if "st1" has no value, the above statement is entering the string "nu;;" in the above table:
SQL>select f1 from mytab:
How can I change my JSP to avoid entering "null" when st1 does not have any content?