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 exist.
*ProgrammingError*: ERROR: column "none" does not exist INSERT INTO
orderitem
(item,quantity,unit,conference,seller,incharge,orderdate,duedate,returnedas)
VALUES (6,10.000000,None,39,1,1,2007-3-16,20-03-2007,None)
args = ('ERROR: column "none" does not exist\n\nINSERT INT...,
10.000000,None,39,1,1,2007-3-16,20-03-2007,None)',)
You're looking for "Null" rather than "None".
Oh, and your dates need to be quoted too.
--
Richard Huxton
Archonet Ltd
