I am having a problem inserting into a table where I have a numeric field that is sometimes null. How do you put a null into a numeric field
For example my sql stmt might be:
insert into t1 (f1,f2,f3) values(?,?,?). If f2 is a numeric field and the corresponding value in my $dbParamValues list is empty, I get an error converting a VARCHAR to numeric. Character values are ok and the db has a null inserted (as desired). I have not figured out how to get around this other than by building the SQL dynamically. (I am using SQL Server as the DB).
Does anyone have a suggestion? Thanks in advance for any help.