Thanks! That's two I owe you.

On Tue, 21 May 2002, Sean Chittenden wrote:

> > How do you get the auto_increment record number for mysql in 
> > ruby/dbi/mysql?
> 
> sql = 'INSERT INTO foo (foo_name) VALUES (?)'
> dbh.do(sql, my_foo_name)
> insert_id = dbh.insert_id
> 
> if insert_id.nil?
>   raise "bad things happened"
> end
> 
> It's untested... but DBD::Mysql#insert_id() should be available via a
> DBH instance.  -sc
> 
> 

-- 
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 Architecture: http://virtualschool.edu/jwaa