On Tue, Oct 31, 2006 at 02:24:46PM +1300, Jake Briggs wrote: > Which database? Serial is a sqlserver thing isn't it? You can't reliably > do this sort of thing on sql server 2003 (I think that's the right > version). My solution was convoluted and annoying, involving a dummy > table to simulate a sequence (like a sequence from postgres) and making > sure to keep the transaction atomic. Could't you get the ids before and after the insert, and do somekind of diff? --------------------- To unsubscribe go to http://gameprogrammer.com/mailinglist.html