[Dbix-class] MSSQL notes

[Alan Humphrey]

I've got .05005

The existing test basicrels/14mssql.t will throw the error.  If you're
looking for something that will demonstrate the error running against SQLite
it'll have to wait a week - I'm headed out of town and will be sans
computer.

- Alan

-----Original Message-----
From: dbix-class-bounces at lists.rawmode.org
[mailto:dbix-class-bounces at lists.rawmode.org] On Behalf Of Matt S Trout
Sent: Saturday, February 18, 2006 10:43 AM
To: dbix-class at lists.rawmode.org
Subject: Re: [Dbix-class] MSSQL notes

On Fri, Feb 17, 2006 at 02:55:05PM -0800, Alan Humphrey wrote:
> Additional notes for anyone using MSSQL:
> 
>  
> 
> 1) using the ODBC driver on Windows I had to use the software_limit
> attribute:
> 
>  
> 
> $it = MSSQLTest::Artist->search( { },
> 
>             { rows => 3,
> 
>                 software_limit => 1
> 
>             }
> 
>             );
> 
>  
> 
> Failure to use the attribute results in
> 
>  
> 
> SQL::Abstract::Limit: Unsupported data struct HASH for ORDER BY at
> /usr/lib/perl5/site_perl/5.8/DBIx/Class/Storage/DBI.pm line 332
 
Which version of DBIx::Class are you using? In current trunk line 332 is

=cut

which somehow seems unlikely to be what's throwing the error ...

I've had this error reported a couple times now, but haven't been able
to re-create it myself - can you manage to pare it down to a test case I
can run against trunk?
 
> Use this info with caution. It's what worked for me, in my limited tests.
> Also, both software_limit and limit_dialect are "public" methods (no
leading
> underscore), but they're undocumented.  I don't know what Matt has in mind
> for them.

Ah. Whoever provided the patch with those accessors in evidently didn't
provide POD patches. Any volunteers?

-- 
     Matt S Trout       Offering custom development, consultancy and support
  Technical Director    contracts for Catalyst, DBIx::Class and BAST.
Contact
Shadowcat Systems Ltd.  mst (at) shadowcatsystems.co.uk for more information

 + Help us build a better perl ORM:
http://dbix-class.shadowcatsystems.co.uk/ +

_______________________________________________
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/