On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Bambero <[EMAIL PROTECTED]> wrote:
> I have little problem with changing order of rows. I have a simple
> table articles:
>
> CREATE TABLE articles (
> id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
> title VARCHAR,
> content VARCHAR,
> order INTEGER UNIQUE,
> );
> when inserting row order is a copy of id (trigger used).
> I have few rows
>
> 1, test1, test1, 1
> 2, test2, test2, 2
> 3, test3, test3, 3
>
> Now i want to "move down" row with id 2, to table looks like this:
>
> 1, test1, test1, 1
> 2, test2, test2, 3
> 3, test3, test3, 2
>
> Any suggestions ? Maybe there is better way to moving rows ?
Perhaps something like this:
update articles set order=-1 where order=:oldorder
update articles set order=:oldorder where order=:neworder
update articles set order=:neworder where order=-1
but how to define the row in this example ?
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
