Alexandr and Wayne ! you saved my life!!
Thanks so much.. it's so simple I feel confused ^_^
I did not look closer to the spelling (and may have been tired of
breaking my teeth)
The trick is just to define the type of 'id' as INTEGER instead of
INT (and to set it as PRIMARY)
This is somet
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.p
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
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 fo
David... read the URL you sent again, specifically:
If a table contains a column of type INTEGER PRIMARY KEY, then that
column becomes an alias for the ROWID. You can then access the ROWID
using any of four different names, the original three names described
above or the name given to the INTEGER
You can have auto-incremented columns with SQLite.
Define a single integer column as primary key and that should do the job.
On 10/25/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
>
> Hello all!
>
> I'm a re-newly cake user and I'm currently trying to make my cake
> using a SQLite database.
Hello all!
I'm a re-newly cake user and I'm currently trying to make my cake
using a SQLite database.
I'll the 15minute blog tutorial as a reference.
Now, once I get the database connected correctly (verified and working
with bake script), I do a simple table :
CREATE TABLE posts (
id INT UN
