Re: [rt-users] DBIx::SearchBuilder How to make left join with epression?

2006-08-03 Thread Todd Chapman
On Mon, Jul 31, 2006 at 12:50:42PM -0400, Todd Chapman wrote: On Mon, Jul 31, 2006 at 12:34:11PM -0400, Jesse Vincent wrote: On Jul 28, 2006, at 5:21 PM, Todd Chapman wrote: How do I do a left join and join on an arbitrary expression? That catch is that I need to refer to the

Re: [rt-users] DBIx::SearchBuilder How to make left join with epression?

2006-07-31 Thread Jesse Vincent
On Jul 28, 2006, at 5:21 PM, Todd Chapman wrote: How do I do a left join and join on an arbitrary expression? That catch is that I need to refer to the TABLE2 alias in the expression? Shouldn't it be enough to use -NewAlias to create a new alias, pass it in as ALIAS2, and go from there?

[rt-users] DBIx::SearchBuilder How to make left join with epression?

2006-07-28 Thread Todd Chapman
How do I do a left join and join on an arbitrary expression? That catch is that I need to refer to the TABLE2 alias in the expression? Also, how can I just give DBIx::SB the proper SQL to run in situations where I can't get it to generate the proper SQL? Thanks. -Todd