Allan Cochrane wrote:
On Fri, Dec 16, 2011 at 5:40 AM, Peter Rabbitson <[email protected] <mailto:rabbit%[email protected]>> wrote:This is correct, DBIC currently has no facility to express arbitrary joins between arbitrary chunks of SQL. What are you actually trying to achieve here? Is there a reason you are not running said query against the handle directly with $schema->dbh_do ?I have been using DBIx::Simple and SQL::Abstract with multiple tables and it was working well. Recently the schema changed and we've moved to a single table so I though I'd use DBIx::Class to do the job, I hoped it might remove the need for some of the fixed SQL I currently have. It would appear that I need to go back to what I had before and adapt that code to the new model. Thanks all for your help.
Aye. Eventually we will have an API to do this seamlessly, but for the time being it's much simpler and cleaner to do it by hand. _______________________________________________ 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]
