I've tested your patch, but i've the same problem i had with a similar
modification.
When you send :
{ table1.key => { '!=' => table2.key } }to _recurse_where, it uses placholders and bind values to generate the query, so the SQL select looks like : SELECT .... FROM table1 JOIN table2 ON (table1.key != ?)table2.key ... Do you've the same problem ? Is there a way to disable placeholder into SQL::Abstract ? Anthony Le lundi 27 novembre 2006 à 12:38 +0100, Bernhard Graf a écrit : > Anthony Hinsinger wrote: > > > After a short investigation of the code, i think the method to fix is > > "_table" into the DBIx::Class::Storage::DBI module. This one convert > > the "from" attribut to a SQL statement. > > There are two options for complex queries in DBIC: > - Use from-attribute > - Avoid from-attribute > > Because I'm not able to build the query without from-attribute, I had to > fix this part in DBIC. Digging in the DBIC code a little bit I learned > that actually all the required code is already there - namely in > SQL::Abstract::_recurse_where() - > DBIx::Class::Storage::DBI::_join_condition just doesn't use the power. -- Anthony Hinsinger <[EMAIL PROTECTED]> _______________________________________________ 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/dbix-class@lists.rawmode.org/
