in reply to DBI and primary keys

select @@identity should do the trick.

now, go get some sleep, man.

Replies are listed 'Best First'.
Re: (boo) Re: DBI and primary keys
by $code or die (Deacon) on Mar 28, 2001 at 00:34 UTC
    That did the trick! Thanks everyone. I'm off home now!!

    ++ all round!

    Update: I was using MS SQL by the way, but I also use mySQL so all the answers were very useful.

    $ perldoc perldoc
[reply]
      Well, since the guts of MS SQL are Sybase (7. something, IIRC), the @@identity thing makes sense.
      --
      Jay "Yohimbe" Thorne, alpha geek for UserFriendly
[reply]

In Section Seekers of Perl Wisdom