Robert Dobbs wrote:
>
>
>>> 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.
>> Be aware, @@IDENTITY can lead to odd things (MSSQL)...
>
> Hey this is pretty weird. DBIx::Class::Storage::DBI::Sybase::MSSQL uses
> @@IDENTITY. So let's just assume that's okay for the moment.
>
> But for some reason, my storage is not a
> DBIx::Class::Storage::DBI::Sybase::MSSQL. Class::C3::calculateMRO yields
> (DBIx::Class::Storage::DBI::Sybase DBIx::Class::Storage::DBI::NoBindVars
> DBIx::Class::Storage::DBI DBIx::Class::AccessorGroup DBIx::Class::Storage
> DBIx::Class DBIx::Class::Componentised Class::Data::Accessor).
>
> That would probably be because my connect info gives no indication that it
> is MSSQL - I am using the FreeTDS sybase driver, and it doesn't need that.
>
> Where do I set storage_type to ::DBI::Sybase::MSSQL?
>
> Mark
In your schema class. It's not really documented in ::Schema, but it's
in the source:
__PACKAGE__->mk_classdata('storage_type' => '::DBI');
I'd assume you can just set it to ::DBI::MSSQL or ::DBI::Sybase::MSSQL
-=Chris
signature.asc
Description: OpenPGP digital signature
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/[email protected]/
