On 11/12/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
Robert Zajda <[EMAIL PROTECTED]>
wrote:
>> 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 ?
I don't understand this question. Order field is unique - why do you
feel "where order = ?" condition does not provide sufficient
identification for the row?
Forgive me, my english is not good enough.
I want to "move up" row with order 2 (on first position - to have order 1).
Maybe it's trivial quastion but should I use:
update articles set order=-1 where order=:oldorder and order=2
update articles set order=:oldorder where order=:neworder
update articles set order=:neworder where order=-1
?
It wont works.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
