[EMAIL PROTECTED] writes:
>
> How do I get the ID used after an INSERT into a table that has an
> auto-assign primary ID column? I've been search all over for the answer but
> I could not find it in any FAQs for anything. I'm using I'm using the
> DBD::ODBC driver.
Depends.
If it's Sybase or MS-SQL you need to do
select @@identity
after the insert.
Michael
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]