From: "Brad Cox, Ph.D." <bcox@...>
Date: 2002-05-27T22:29:59+09:00
Subject: Re: DBI access to mysql auto_increment record numbers?

Another way I found on my own

	id = dbh.handle.__insert_id;

On Sun, 26 May 2002, Sean Chittenden wrote:

> > Sean, sorry if I'm being obtuse, but this isn't working out.
> 
> Yeah, I was wrong about that.
> 
> > Am I using the right software? Suggestions?
> 
> with ruby-mysql 0.3.3 and dbi .15, you should be able to do:
> 
> dbh.func('insert_id')
> 
> Michael Neumann posted the way for how you do that recently... I can't
> remember the specifics.  I believe it was on ruby-talk though.  I
> think the 1st one works, but I'm not sure.
> 
>  dbh.func(:insert_id)
>  dbh.insert_id
>  dbh['insert_id']
> 
> 
> <puts_on_running_shoes/> Might I suggest using PostgreSQL instead?
> Select curval('my_seq_id') is slightly more general.  <runs_to_door/>
> 
> 

-- 
Brad J Cox, Ph.D. bcox@virtualschool.edu, 703 361 4751
For industrial age goods there were checks and credit cards
For everything else, there is http://virtualschool.edu/mybank
Java Web Application Environment: http://virtualschool.edu/jwaa
Interactive Learning Environment: http://virtualschool.edu:8083