New Project Information
dbconnect(); /* The SQL statment to insert a new project into the database is constructed here based upon the values obtained from the form elements in the form at the bottom of this html page which are passed as properties of the REQUEST object. */ companies = database.cursor("SELECT * FROM Companies ORDER BY CompanyName") if(request.projectname && request.companyname) { projectexists = database.cursor("SELECT * FROM project WHERE projectname = '" + request.projectname + "'") if(!projectexists.next()) { database.execute("insert into project values ('" + request.projectname + "','" + request.companyname + "','" + request.techdesc + "')") redirect("viewproj.html?project=" + escape(request.projectname)) }else { write(" That project name already exists. Please use a different name.") } }
Project Name*
Company Name*
Technical
Description

* Required Fields

When completed, click on 'Submit' to add Project Team information: