I've changed suspect column titles to avoid any reserved word conflicts and I've modified the " $this->Debug = true;" line in the mysqli/queryobj.php file which now gives a more expanded error:
INSERT INTO opp_workassign (Submit Date, Name, Username, Email, Phone, Building, Floor, Room, Category, Urg_Norm, Description) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Date, Name, Username, Email, Phone, Building, Floor, Room, Category, Urg_Norm, D' at line 1
Any ideas what is causing the error?
UPDATE: I just removed all of the MySQLi behaviors and replaced them with the DW CS6 legacy behaviors - and everything worked perfectly - 1st try. I re-applied the MySQLi behaviors and the SQL syntax error returned. So it is something involving the MySQLi extension that is causing my grief. Does this update give you any clues?? I really need to resolve this since this page is expected to be placed into production tomorrow.