Re: Time to standardize the ``last insert id'' concept...

2003-03-11 Thread Michael Peppler
On Mon, 2003-03-10 at 15:50, Tim Bunce wrote: On Mon, Mar 10, 2003 at 02:50:08PM -0800, Michael Peppler wrote: On Mon, 2003-03-10 at 12:36, Tim Bunce wrote: Taking a different tack... *if* @@identity is a sequence and AutoCommit is off then then select max($column) from $table would

Re: Time to standardize the ``last insert id'' concept...

2003-03-11 Thread Tim Bunce
On Tue, Mar 11, 2003 at 09:20:48AM -0800, Michael Peppler wrote: On Mon, 2003-03-10 at 15:50, Tim Bunce wrote: On Mon, Mar 10, 2003 at 02:50:08PM -0800, Michael Peppler wrote: On Mon, 2003-03-10 at 12:36, Tim Bunce wrote: Taking a different tack... *if* @@identity is a sequence and

Re: Time to standardize the ``last insert id'' concept...

2003-03-11 Thread Michael Peppler
On Tue, 2003-03-11 at 12:50, Tim Bunce wrote: [ignore the previous 'empty' reply, finger trouble] On Tue, Mar 11, 2003 at 09:20:48AM -0800, Michael Peppler wrote: On Mon, 2003-03-10 at 15:50, Tim Bunce wrote: On Mon, Mar 10, 2003 at 02:50:08PM -0800, Michael Peppler wrote: On Mon,