request.table= "" + request.table.substring(0, 1).toUpperCase() + request.table.substring(1, request.table.length).toLowerCase(); header("Processing "+request.table+" Update", project.HDefaultImage, ""); //#### needs own image #### function eSave() { var ecode = database.execute("UPDATE " + table + " SET" + bindings + " WHERE " + keyField + " =" + keyValue); if (ecode==0){ write("
Your changes to the " + table + " record have been saved."); }else{ write("
An error was detected in attempting to save your changes: "+ecode+". " +database.majorErrorMessage()+" "+database.minorErrorMessage()); }; return true; }; function insertNewRecord() { var ecode = database.execute("INSERT INTO " + table + " (" + cols + ") VALUES (" + vals + ")"); if (ecode==0){ write("
Your new " + table + " record has been saved."); }else{ write("
An error was detected in attempting to save your new " + table + " record: "+ecode+". " +database.majorErrorMessage()+" "+database.minorErrorMessage()); }; }; //------------------end function definitions. BEGIN toplevel statements-------- table=request.table; // write("
MODE="+request.mode); // write("
Table="+table); fields = new FieldsList(table); keyField = (request.keyField==null) ? fields.keyField : request.keyField; cols=""; vals=""; bindings=""; leader=" "; if (request.mode!="edit") { //On an add or copy, let jid be bound to 0. //On an edit, jid is unbound and used in the WHERE clause. eval("request."+keyField+"=0"); fields.lengthBindable=fields.lengthBindable+1; }; keyValue=eval("request."+keyField); bindVariables(); // write("
BINDINGS= " + bindings); flush();


dbConnect(); eval(table.toLowerCase()+"ListingsReusable="+Q+"false"+Q); eval(table.toLowerCase()+"OptionsReusable="+Q+"false"+Q); if (request.mode=="edit") { eSave() } else { insertNewRecord(); }; dbDisconnect();

write(button("Continue", null, null))


footer()