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