null params dates about yank HOT 4 CLOSED

I'd love to help. Can you be more specific?

from yank.

i get this error:

java.sql.SQLException: Data truncation: Incorrect date value: '' for column 'fechacad' at row 1 Query: INSERT INTO inventarios (Cod_Mov, Cod_Almacen, Cod_Proveedor, Cod_Articulo, tipodesc, Cod_IVA, cod_sesion, claveEmpleado,Stock_Mov, descuento_Mov, Costo_Mov, prov_garantia, IVA,Fecha_Mov,Hora_Mov, Cod_Caja,Doc_Fuente, paquete,Tipo_Mov,desc_mov,num_serie,lote,fechacad) VALUES (null, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,?,?) Parameters: [[5, 1, 581, 1, 1, 13747, 12, 1, 0.0, 36.00, 0, 4.97, 2013-08-17, 12:43:00, 1050000099611, 99611, 0, S, V, , , ]]

i want set null to "fechacad" column.

i try with '', 'null', etc.

from yank.

it looks like you're passing in 22 parameters but your SQL statement is expecting 23. Is that the problem?

from yank.

not, in my code the params match ok.
i have double checked it.

I think the problem arises because the quotes are added automatically to the parameter.
and then the parameter is never passed as null (without quotes).
when I put directly the parameter to null the query runs perfectly.

from yank.