On Tue, Jul 06, 2010 at 08:08:40PM +0000, Mark wrote:
> I have a unique column, and need two rows to swap their values. 
> Is there a way to make the 2 updates at the same time or do I 

   Can you do that with pure SQL?

> have to update one of them to an unused value in the DB then 
> make the swap? 

   Yes, I think this is the way to go.

Oleg.
-- 
     Oleg Broytman            http://phd.pp.ru/            p...@phd.pp.ru
           Programmers don't die, they just GOSUB without RETURN.

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to