[Dbix-class] can't get PK::Auto with MSSQL thru Sybase - fix?

[Robert Dobbs]

>From: "Robert Dobbs" <bobisdobbs at hotmail.com>
>
>           * For some drivers the value may only be available if 
>placeholders
>           have not been used (e.g., Sybase, MS SQL). In this case the 
>value
>           returned would be from the last non-placeholder insert 
>statement.
>
>Bleah.  I guess I have to use SQL and be very careful about de-sqlifying 
>input.

Hey guess what.  This doesn't seem to matter.  As a test, I changed line 941 
of DBIC:Storage::DBI to do "return $self->dbh->selectrow_array('SELECT 
@@IDENTITY')" and it works great.  I think the subclassed PK::Auto for 
MS-SQL needs to be brought back to life.

Mark

_________________________________________________________________
Check the weather nationwide with MSN Search: Try it now!  
http://search.msn.com/results.aspx?q=weather&FORM=WLMTAG