[Dbix-class] JOIN question

Bernhard Graf dbic2 at augensalat.de
Tue Nov 28 14:39:24 GMT 2006


Anthony Hinsinger wrote:

> 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, you are right.
For the moment { 'table1.key' => \'!=table2.key' } does the job.

I will look at the problem - and also write some tests. ;-)

-- 
Bernhard Graf



More information about the Dbix-class mailing list