DBManager executeUpdate and null values

[jgrotto]

Is it possible to send null values as a argument to a insert/update using the executeUpdate method of the SFS Database Manager. The database field is set to allow null values. Sending a Java null results in a NullPointerException.

Thanks!

[rutabuga]

you mean like this, the following code sets all second names in table to NULL

Code: Select all

sql = "UPDATE `table` SET `secondname`= ?;
    			
    	Object[] array = new Object[1];
    	array[0] = null;
    	dbManager.executeUpdate(sql, array);

[jgrotto]

Thanks... I will try that.

For whatever reason, that didn't seem to work in my tests, but I'll give it a try.