[Dbix-class] MSSQL notes

[Matt S Trout]

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