if ($opt_debugLog == 'False') {
         $log->opt_debug = false;
     } else {
         $log->opt_debug = true;
     }
 }
 $opt_logLoc = $sql->getOption('Log_File_Location');
 if ($opt_logLoc === false) {
     $log->add_log($sessionID, 'Warning', 'RetriveItem Warning: Log_File_Location Option missing or invalid.');
 } else {
     $log->set_log_location($opt_logLoc);
 }
 $runLevel = $sql->verifySID($sessionID);
 //No special permission required.
 $IMSBase->verifyData($partNumber, "/^.+\$/", "Part Number");
 $stmt = $sql->prepare("SELECT * FROM dbo.Inventory WHERE Name='{$partNumber}'");
 $stmt->execute();
 $result = $stmt->setFetchMode(PDO::FETCH_ASSOC);
 if (count($result) == 0) {
     $statusCode = '1';
     $statusMessage = "RetrieveItem: Part Number,{$partNumber}, does not exist in database.";
     $log->add_log($sessionID, 'Warning', $statusMessage);
 } else {
     if (count($result) > 1) {
         $statusCode = '1';
         $statusMessage = "RetrieveItem: Part Number,{$partNumber}, has multiple instances in database.";
         $log->add_log($sessionID, 'Warning', $statusMessage);
     } else {
         $dataArray = $stmt->fetch(PDO::FETCH_ASSOC);
         $statusCode = '0';
         $statusMessage = "RetrieveItem: Part Number ,{$partNumber}, data has been retrieved.";
 if ($opt_logLoc === false) {
     $log->add_log($sessionID, 'Warning', 'ModifyClassData Warning: Log_File_Location Option missing or invalid.');
 } else {
     $log->set_log_location($opt_logLoc);
 }
 $runLevel = $sql->verifySID($sessionID, "1");
 //1 = Requires edit privileges.
 $IMSBase->verifyData($recordID, "/^.+\$/", "Record ID");
 $IMSBase->verifyData($field, "/^.+\$/", "Record Field");
 $IMSBase->verifyData($value, "/^.+\$/", "Record Value");
 $IMSBase->verifyData($sortColumn, "/^.*\$/", "Sort Column");
 if ($sortColumn != "") {
     $IMSBase->verifyData($sortDirection, "/^(ASC|DESC)\$/", "Sort Direction");
 }
 if ($field == 'Part') {
     $stmt = $sql->prepare("SELECT [Part] FROM dbo.Class_Data WHERE [id]='{$recordID}';");
     $stmt->execute();
     $oldPN_array = $stmt->fetchAll(PDO::FETCH_ASSOC);
     $oldPN = $oldPN_array[0]['Part'];
     //remove lab part flag from old part number
     $sql->command("UPDATE dbo.Inventory SET [Lab_Part_Flag]='0' WHERE [Name]='{$oldPN}';");
     //add lab part flag from new part number
     $sql->command("UPDATE dbo.Inventory SET [Lab_Part_Flag]='1' WHERE [Name]='{$value}';");
 }
 $sql->command("UPDATE dbo.Class_Data SET [{$field}]='{$value}' WHERE ID='{$recordID}';");
 //retrieve new table.
 $sqlQuery = "SELECT * FROM dbo.Class_Data";
 if ($sortColumn != "") {
     $sqlQuery = $sqlQuery . " ORDER BY {$sortColumn} {$sortDirection}";
 }
 $sqlQuery = $sqlQuery . ";";
    }
    $opt_logLoc = $sql->getOption('Log_File_Location');
    if ($opt_logLoc === false) {
        $log->add_log($sessionID, 'Warning', 'ModifyEmailAddress Warning: Log_File_Location Option missing or invalid.');
    } else {
        $log->set_log_location($opt_logLoc);
    }
    $runLevel = $sql->verifySID($sessionID, "1");
    //1 = Requires edit privileges.
    $IMSBase->verifyData($recordID, "/^.+\$/", "Record ID");
    $IMSBase->verifyData($field, "/^.+\$/", "Record Field");
    $IMSBase->verifyData($value, "/^.+\$/", "Record Value");
    $sql->command("UPDATE dbo.Emails SET [{$field}]='{$value}' WHERE ID='{$recordID}';");
    //retrieve new table.
    $sqlQuery = "SELECT * FROM dbo.Emails;";
    $stmt = $sql->prepare($sqlQuery);
    $stmt->execute();
    $dataArray = $stmt->fetchAll(PDO::FETCH_ASSOC);
    $statusCode = '0';
    $statusMessage = "Email record({$recordID}) - {$field} was updated with {$value}";
    $log->add_log($sessionID, 'Information', $statusMessage);
} catch (PDOException $e) {
    $statusCode = '1';
    $statusMessage = 'ModifyEmailAddress SQLError: ' . $e->getMessage();
    $log->add_log($sessionID, 'Error', $statusMessage);
} catch (Exception $e) {
    $statusCode = $e->getCode();
    $statusMessage = 'ModifyEmailAddress Error: ' . $e->getMessage();
    if (!$log->add_log($sessionID, 'Error', $statusMessage, "N/A", true)) {
        $statusMessage = $statusMessage . " **Logging Failed**";
    }