Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Error: ER_NO_REFERENCED_ROW_2: Cannot add or update a child row: a
- foreign key constraint fails (`employee`, CONSTRAINT
- `fk_Employee_Exhibits1` FOREIGN KEY (`EnclosureID`) REFERENCES `enclosure`
- (`Enclosure`) ON DELETE NO ACTION ON UPDATE NO ACTION
- var entry = {
- 'Zoo ID': 1,
- 'First Name': $("#firstNameEntry").val(),
- 'Last Name': $("#lastNameEntry").val(),
- 'Enclosure ID': enclosure.options[enclosure.selectedIndex].id,
- 'Shop ID': shop.options[shop.selectedIndex].id,
- 'Job Desciption': $("#jobDescriptionEntry").val(),
- 'Hire Date': today,
- 'Shifts': $("#shiftEntry").val(),
- 'Salary': $("#salaryEntry").val()
- };
- insertEmployee = function(data, callback){
- var sql = "INSERT INTO employee SET ?"
- console.log(data)
- pool.getConnection(function(err, connection) {
- if(err) { console.log(err); callback(true); return; }
- // make the query
- connection.query(sql, data, function(err, results) {
- connection.release();
- if(err) { console.log(err); callback(true); return; }
- callback(false, results);
- });
- });
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement