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