#13 Insert New Project for Department

[Anonymous]

Inserting a new project for a department I get a Insert
field for 'dateposted' field not found..

>>
You are logged in as Administrator Administrator
SQL Error Occured : Unknown column 'dateposted'
in 'field list':INSERT INTO project (projectid, deptid,
projecttitle, projectdesc, dateposted, hoursworked,
active) VALUES (null, '3', 'ee', 'ee', '2003-10-02
16:15:14', '0', 'y')
<<

i took a look at it and yep.. no dateposted..

[Nobody/Anonymous]

Logged In: NO

me, too (bayardk@acm.org) 12/31/03. ALTERed table to fix.

[Nobody/Anonymous]

Logged In: NO

Altered table the following way:

alter table project add dateposted timestamp NOT NULL after
projectdesc;

Also the ID field should not be set using a default value
(no default value with auto_increment fields).

Will.