Re: [SQL] no value for numeric filed in SQL statement causes an error

2001-02-05 Thread Ian Harding
[EMAIL PROTECTED] wrote: > Hi there > > I have a table with char and int fields. From my form I get no values back > for int fields when they are left blank. This causes the SQL insert to > fail. > > field type > name char > id int2 > city char > > insert into table (name,id,city) values (

[SQL] no value for numeric filed in SQL statement causes an error

2001-01-31 Thread juerg . rietmann
Hi there I have a table with char and int fields. From my form I get no values back for int fields when they are left blank. This causes the SQL insert to fail. field type name char id int2 city char insert into table (name,id,city) values ('roger rabbit',,'carrot city') The default for