Good solutions Richard, nice one.
You may want to look into specifying the 'on' part of the validation
rule, which allows you to set whether the validation is done on
creating a new record, or updating an existing one. I'm not sure how,
if at all, that would tie into the code you've provided here.
On Nov 30, 9:43 am, RichardAtHome <[EMAIL PROTECTED]> wrote:
> If anyone else is looking for some drop in code to handle unique
> validation, here's what I came up with.
>
> This is a generic function you can drop into your app_model:
>
> /**
> * checks is the field value is unqiue in the table
> * note: we are overriding the default cakephp isUnique test as the
> original appears to be broken
> *
> * @param string $data Unused ($this->data is used instead)
> * @param mnixed $fields field name (or array of field names) to
> validate
> * @return boolean true if combination of fields is unique
> */
>
> function checkUnique($data, $fields) {
>
> if (!is_array($fields)) {
>
> $fields = array($fields);
>
> }
>
> foreach($fields as $key) {
>
> $tmp[$key] = $this->data[$this->name][$key];
>
> }
>
> if (isset($this->data[$this->name][$this->primaryKey])) {
>
> $tmp[$this->primaryKey] =
> "<>".$this->data[$this->name][$this->primaryKey];
>
> }
>
> return $this->isUnique($tmp, false);
>
> }
>
> }
>
> and is used in your model validate:
>
> var $validate = array(
> "name"=>array(
> "unique"=>array(
> "rule"=>array("checkUnique", array("name",
> "institution_id")),
> "message"=>"A contact with that name already
> exists for that
> institution"
> )
>
> )
> );
>
> It will handle single or multiple fields. e.g. In the example above,
> the combination of name AND instution_id must be unique.
>
> It also handles the 'edit' gotcha too.
>
> Thanks for all your help :-)
>
> On Nov 30, 6:35 am, RichardAtHome <[EMAIL PROTECTED]> wrote:
>
> > Thanks for the additional feedback.
>
> > I'd already discovered the 'edit' gotcha and created a workaround
> > similar to Involution's.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
