In my applications, that i have using sqlite 2, add this solution: app_model: function getNextId() { $_max = $this->query("SELECT (MAX(id) + 1) AS id FROM {$this->table}"); $max = $_max[0][0]['id'];
return ceil($max); } and, in for example, photos_controller.php: function add() { if ($this->data) { ... $this->data['Photo']['id'] = $this->Photo->getNextId(); ... } } Sorry for my bad english to explain the idea.. Thiago Paes --- On 10/25/07, Grant Cox <[EMAIL PROTECTED]> wrote: > > > That's "easy"? Sounds like a ridiculously over-complex idea to me... > > > On Oct 25, 2:01 pm, Adwin Wijaya <[EMAIL PROTECTED]> wrote: > > The easiest one :) > > > > create a table called counter with 2 field (or one,. deppend on you) > > create table tcounter > > :ctrtype "nameoftable" > > :ctrvalue 0 > > > > when you want to save (inserting) ... get the ctrvalue from the > > tcounter first, and then insert the ctrvalue into your table :id > > (primary key). dont forget to update the tcountr after you > > successfully inserting (update tcountr set ctrvalue = ctrvalue + 1 ) > > > > done :) > > > -- ________________________________________________________ Thiago Paes - WebDeveloper - Linux user: #224062 site: http://www.thiagopaes.com.br --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---