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

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 null,

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

2007-03-15 Thread Parthan SR
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 null, incharge integer not null, orderdate date not null, duedate date