Back in October, I responded to a request from Michael Higgins on this list for help with last insert ID for MSSQL over ODBC. http://lists.scsys.co.uk/pipermail/dbix-class/2007-October/005107.html
I don't use MSSQL myself, so Michael tested the resulting module and I committed it to 0.08/trunk, today. http://dev.catalyst.perl.org/svnweb/bast/view/DBIx-Class/0.08/trunk/lib/DBIx/Class/Storage/DBI/ODBC/Microsoft_SQL_Server.pm There is another MSSQL storage module in tree, written by Brian Cassidy, Storage::DBI::MSSQL. In the new, ODBC::Microsoft_SQL_Server, I used SELECT SCOPE_IDENTITY which is a bit safer than the @@IDENTITY used in Storage::DBI::MSSQL, especially in the presence of triggers. It required a bit more hoop jumping, though, since SCOPE_IDENTITY must be called in the same execute call, not just the same connection. Both modules should probably share the same implementation. I discussed that briefly with Brian, via e-mail, and he gave me permission to make any changes necessary to the MSSQL module he authored. I'd be happy to do that, but since I don't actually use MSSQL myself and don't have a system to test with both DBD::Sybase and DBD::ODBC, I could use some help. If someone else with interest in the MSSQL code wants to jump in, or if someone can offer me access to a system for testing, we can eliminate a bit of code by sharing the same implementation for both. In fact, if my implementation works for Storage::DBI::MSSQL, then DBI::ODBC::Microsoft_SQL_Server can probably be reduced to single line of code: use base qw/DBIx::Class::Storage::DBI::MSSQL/; -Marc _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[EMAIL PROTECTED]
