Re: Problem with saving id's

2009-09-30 Thread brian
Oracle uses triggers to implement "auto increment" functionality. Cake deals with that but I think it expects the sequence name to be "pk_$table_name". Is that what you have? Hmm ... looking at the source, it appears that you can set the sequence name in the model: $model->sequence. On Wed, Sep

Re: Problem with saving id's

2009-09-30 Thread John Andersen
I am not sure, but as far as I know, you have to get the new ID from the sequence yourself. Whether you can persuade CakePHP to do it (don't know how, maybe "id = your_seq.NEXTVAL") or maybe add a before insert trigger to get the new ID from the sequence (if it can be done!). Enjoy, John On Se