MySQL Duplicate entry / Which column?

For I'm not sure I made myself clear ;o), here is an example

try {
            $objNewArtiste->Save();
            QApplication::Redirect('./');
        }
        catch (QMySqliDatabaseException $objExc) {
            if ($objExc->ErrorNumber == 1062) {
                // MySqli Error: Duplicate entry
                // Which column causes the duplicate entry Exception?
                $objTestArtiste = Artistes::LoadByEmail($this->txtEmail->Text);
                if (is_object($objTestArtiste)) { $this->txtEmail->Warning = 'uplicate entry'; }
                $objTestArtiste = Artistes::LoadByPseudo($this->txtPseudo->Text);
                if (is_object($objTestArtiste)) { $this->txtPseudo->Warning = 'duplicate entry'; }
            }
        }

Is there a better way?

Hi guys,
with your suggestions, I solved the problem in the following way, using loadBy instead of try/catch:

    protected function btnSave_Click($strFormId, $strControlId, $strParameter) {
        //$withDuplicates stores the result of validation on duplicate entries
        $withDuplicates= false;

        //first validation for the form field "AssignedCardNumber"
        $obj = People::LoadByAssignedCardNumber($this->txtAssignedCardNumber->Text);
        if (is_object($obj) && $obj->Id != $this->lblId->Text){
            $this->txtAssignedCardNumber->Warning = 'value already used';
            $withDuplicates = TRUE;
        }

        //second validation for the form field "Email"
        $obj = People::LoadByEmail($this->txtEmail->Text);
        if (is_object($obj) && $obj->Id != $this->lblId->Text) {
            $this->txtEmail->Warning = 'value already used';
            $withDuplicates = TRUE;
        }

        //if duplicates were found, saving function is aborted
        if ($withDuplicates)
            return;
    
        //no duplicates, go on saving...
        // Delegate "Save" processing to the PeopleMetaControl
        $this->mctPeople->SavePeople();
        $this->RedirectToListPage();
    }

the following condition

(is_object($obj) && $obj->Id != $this->lblId->Text) 

checks if the validation on the field with unique constraint fails: the condition is true if simultaneously:
- there is still a person in the table People with the 'mail' or 'assignedCardNumber' entered
- and this person is not the person that is currently under editing.

It could be very useful making Qcodo automatically generate this validation-code for any UNIQUE CONSTRAINT in the fields of a DB table
Thank you!

Hi Mike and all,
few minutes ago I moved the validation-code to the FormValidate() function, that is surely a better place than the previous one (About your questions about MVC...I'm going to think about) and the result is surely better:

        protected function Form_Validate() {
            // By default, we report that Custom Validations passed
            $blnToReturn = true;
                        //... other eventual validation...



            // Custom Validation Rules
            $obj = People::LoadByAssignedCardNumber($this->txtAssignedCardNumber->Text);
            if (is_object($obj) && $obj->Id != $this->lblId->Text){            
                $this->txtAssignedCardNumber->Warning = 'value already used';
                $blnToReturn = false;
            }
            $obj = People::LoadByEmail($this->txtEmail->Text);
            if (is_object($obj) && $obj->Id != $this->lblId->Text) {
                $this->txtEmail->Warning = 'value already used';
                $blnToReturn = false;
            }
                


            //... blink code ...
            return $blnToReturn;
        }

but anyway I found a problem: the condition uses “$this->lblId->Text”, but it is not always sure that there is the item 'lblId' in the form (maybe it could be an hidden field).

Yes, I was thinking about.
I changed the condition in:

is_object($obj) && $obj->Id != $this->mctPeople->getObjPeople()->Id

but I needed to create the function 'getObjPeople' in the 'PeopleMetaControlGen' class

        public function getObjPeople() {
            return $this->objPeople;
        }

maybe there is still implemented the possibility to get the 'Id' value, but I didn't find it.
Thank you.

Ok! I found it. Thank you.