my $insert_handle = $dbh->prepare(qq{UPDATE Assignment SET Type = ?, Purpose= ?, Application = ?, Use = ?, Name = ?, Department = ?, Campus = ?, Building = ?, Room = ? WHERE AssetTag = ? });
$insert_handle->execute('Permanent','Native','Lab - Classroom','Academic','-','Center For Computer Services','Manhattan','7th floor','729',$assettag);
DBD::mysql::st execute failed: called with 13 bind variables when 0 are needed at ./new-assignments.pl line 46.
DBD::mysql::st execute failed: 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 'Use = 'Academic', Name = '-', Department = 'Center For Computer Services', Campu' at line 1 at ./new-assignments.pl line 48.