[Dbix-class] Example confusion -- my own

2006-06-22 Thread Alex Beamish
Hi,I'm just getting up to speed on DBIx::Class as a precursor to doing Great Things (I hope) with Catalyst. When I do that kind of thing, I like to do all of the examples so I can really understand them. It all makes sense with the exception of the join in the result set call. First, the example

Re: [Dbix-class] Example confusion -- my own

2006-06-22 Thread Alex Beamish
On 6/22/06, Justin Guenther [EMAIL PROTECTED] wrote: On 6/22/06, Alex Beamish [EMAIL PROTECTED] wrote: Here's the first one that has me stumped .. # SELECT me.cdid, me.artist, me.title # FROM cd me #LEFT JOIN track tracks ON ( tracks.cd = me.cdid )#WHERE ( tracks.title = ? ) #(`Stan') sub

Re: [Dbix-class] Example confusion -- my own

2006-06-22 Thread Ash Berlin
Alex Beamish wrote: So join = 'tracks' doesn't mean join to the `tracks' table, it means join to the `tracks' relationship, which happens to exist on the `track' table. Just like in the first example you gave `cd' didn't refer to a table, it referred to a relationship that

Re: [Dbix-class] Example confusion -- my own

2006-06-22 Thread Alex Beamish
On 6/22/06, Ash Berlin [EMAIL PROTECTED] wrote: Alex Beamish wrote: So join = 'tracks' doesn't mean join to the `tracks' table, it means join to the `tracks' relationship, which happens to exist on the `track' table. Just like in the first example you gave `cd' didn't refer to a table, it