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
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
