hi,all.in this state.
insert into some_table (
id,
state,
date
) values (
#id:NUMERIC#,
#state:VARCHAR#,
#date:DATE#
)
#state:VARCHAR#,in the configure file,we can set the column's type.but is
there anyway to set it's length. if we can do that the check work will be
more easy
Hi all,
I faced with the same problem and I solved in this way:
insert id=insert_dynamic parameterClass=Input
INSERT INTO some_table
dynamic prepend= (
isNotNull prepend=, property=id
I am not sure why people continue to do this
why not
insert into some_table (
id,
state,
date
) values (
#id:NUMERIC#,
#state:VARCHAR#,
#date:DATE#
)
This way it will insert the right data every time. If the value is
null you get a null in the DB. I think you are only going to