Re: Edit record validation versus New record validation (Solved)

Found my own answer/solution with this custom validator. I put this
in my app_model and then can use it from any model. You use it as a
rule as you would any core validator:

[code]
var $validate = array(
'partnumber' => array(
'rule1' => 'validateUniqueness',
'message' => 'This part number is not unique')
)
[/code]

And the code is:

[code]
/**
* Fails if given value for field is not unique for that field in the
table.
*
* @param <type> $fieldData - array(fieldname => fieldvalue)
* @return <type> - true if unique.
*/
function validateUniqueness($fieldData) {
$fields = array_keys($fieldData);
$fieldName = $fields[0];

$values = array_values($fieldData);
$fieldValue = $values[0];

// To determine whether we are going to insert (new) or update
(edit)
// get the current row ID. If empty then this is a new record
// if not then it is an edit record.

// If this is an edit then exclude the currentRow (the one we are
// editing) from the uniqueness test by adding a condition.

$currentID = $this->getID();
if (!empty($currentID) or $currentID = 0) {
$rowID = $this->data[$this->name][$this->primaryKey];
$condition = ' AND ' . $this->name . '.' . "$this->primaryKey !=
'$rowID'";
} else {
$condition = '';
}

if ($this->findCount("$fieldName = '$fieldValue' $condition", -1) >
0) {
return false;
} else {
return true;
}
}
[/code]

Rick
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to cake-php+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---