Re: [GENERAL] Column does not exist when trying to insert data.

2007-03-16 Thread Adrian Klaver
On Thursday 15 March 2007 9:52 pm, Parthan SR wrote: > Hello, > > My table 'orderitems' looks like this > > create table orderitem ( > id serial not null primary key, > item integer not null, > quantity numeric(6,2) not null, > unit varchar(10), > conference integer not null, > seller integer not n

Re: [GENERAL] Column does not exist when trying to insert data.

2007-03-16 Thread Richard Huxton
Parthan SR wrote: I get the following error in the browser, whent he fields for unit and returnedas are left blank and hence becomes None. I also tried to have some string value such as 'nos' and 'not reqd' for 'unit' and 'requiredas' but still it get a similar error saying column 'nos' does not