Re: How do you get last insert ID after changing primary key?

I also tried changing primary key back to ID and still get NULL from getInsertID()


On Wednesday, August 7, 2013 6:34:57 PM UTC+10, Jas wrote:

I want to "insert or update if exist" a table where the column is 'mac' is to be unique and not the primary key.
So I used:
            //change primary key to mac
            $this->Office->Customer->primaryKey = 'mac';
            $customer['Customer']['mac'] = $mac;

            if($this->Office->Customer->save($customer)){
                 //get the Customer ID that was inserted or updated
                 $office['Office']['customer_id'] = $this->Office->Customer->getInsertID();
                   ....
                   ....
            }

Because I change primaryKey, getInsertID returns NULL.  Setting the column to unique causes a duplicate error.

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/groups/opt_out.