On Mon, 30 Mar 2009 12:49:03 -0500 Chris Burch wrote: > Is there a way to get my array into that 'in(?)'?
If your RDBMS and DBD supports SQL arrays, then probably: With the DBIx::Class 0.08100 release candidates (or trunk from Subversion) and SQL::Abstract 1.51 DBIC passes arrayref bind parameters down to DBI. From that point it depends on the DBD and the RDBMS - if it can interpret it as an SQL array (eg. with PostgreSQL and DBD::Pg it works). I can't test it on MS SQL Server, and I don't even know if it has the concept of arrays. And probably you have to write the SQL a bit differently, as IN doesn't take SQL arrays (eg. in PostgreSQL you would have to write 't.sectionid = ANY (?)'). But, first of all, is it necessary to use a literal SQL based ResultSource? I don't see anything in your SQL query that cannot be done with pure DBIC.. norbi _______________________________________________ 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]
