Gimmie a couple days, I'll fix it. A test case or something would be nice though. ;-)
On Feb 22, 6:47 pm, rtconner <[EMAIL PROTECTED]> wrote: > ya, but if that type option is supposed to work.... > > .. blah ... should continue this in trac?https://trac.cakephp.org/ticket/4085 > > On Feb 22, 3:51 pm, Baz <[EMAIL PROTECTED]> wrote: > > > Didn't I just post an alternative? > > > On Fri, Feb 22, 2008 at 2:33 PM, rtconner <[EMAIL PROTECTED]> wrote: > > > > I can't get array('type' => 'INNER') to work wither. > > > > On Feb 22, 12:26 pm, Baz <[EMAIL PROTECTED]> wrote: > > > > Maybe the core developers can reveal this mystery about type => 'INNER' > > > > > I haven't seen this documented any where. > > > > > And as you can see in the first link sent, I didn't work for me...and > > > > there's no response. What did work, is a pseudoINNERjoin, which get's > > > the > > > > job done: > > > > >http://groups.google.com/group/cake-php/browse_thread/thread/77cc0617... > > > > (funny, there are like 6 more responses to this that I can see in my > > > email, > > > > but not in the group) > > > > > Basically, you do a dummy hasOne bind and in your find do a condition: > > > > "Where Dummy.id IS NOT NULL"... > > > > > On Fri, Feb 22, 2008 at 12:37 PM, rtconner <[EMAIL PROTECTED]> wrote: > > > > > > Re: GROUP BY, > > > > > Yeah.. sometimes with group by you have to prepend DISTINCT to the > > > > > primary key to prevent duplicates. I can try to find a query example > > > > > if you really have never come across this. It's pretty common. I have > > > > > some hacks to do this, but if cake really supported grouping, I would > > > > > not be hacking anything. > > > > > > Also, > > > > > I saw thatINNERJOINin the translation behavior. I tried to play > > > > > with that, but never got anything to work. That code is not a > > > > > relationship definition (as nate revealed will work in that posting) > > > > > but it is a query in array format. Normal cake usage does not have any > > > > > place where you build things like that. > > > > > > Anyways... > > > > > Really thanks for the links. Very helpful to know. > > > > > > On Feb 22, 9:17 am, "[EMAIL PROTECTED]" > > > > > <[EMAIL PROTECTED]> wrote: > > > > > > Re:INNER > > > >JOINhttp://groups.google.com/group/cake-php/browse_thread/thread/9f092441... > > > > > > > I believe the TranslateBehavior uses anINNERJOINif you're looking > > > > > > for an example on how to dynamically change the binding although I > > > > > > haven't actually used this myself yet > > > > > .http://api.cakephp.org/1.2/translate_8php-source.html#l00070 > > > > > > > For GROUP BY I believe the norm is to use the conditions to pass in > > > > > > your group by clause > > > > .https://trac.cakephp.org/browser/branches/1.2.x.x/cake/tests/cases/li... > > > > > > > When has this not proved sufficient? Do you have a specific example? > > > > > > > On Feb 21, 6:51 pm, rtconner <[EMAIL PROTECTED]> wrote: > > > > > > > > I have no found a good way to do GROUP BY queries orINNERJOIN's > > > in > > > > > > > cake. > > > > > > > Was wondering if any of you have come across these and how you > > > handled > > > > > > > them. I have not been able to do either of them in conjunction > > > with > > > > > > > the find() method in any normal way.Perhaps I am missing > > > something? > > > > > > > I'd love to find out if I am. Are these some sort of database > > > specific > > > > > > > constructs? > > > > > > > > With Group by, sometimes I can get away with appending > > > $conditions[] = > > > > > > > 'GROUP BY field'; annd the in addition to that, manually passing > > > in > > > > > > > the fields to find() and prepending DISTINCT to the id column. > > > > > > > >InnerJoinI have seen zero support from in Cake. Any time I've > > > wanted > > > > > > > toInnerjoinI've had to write the query manually. You know, > > > > > > > sometimes you just need to filter your queries based on two > > > tables, > > > > > > > not just your primary table. > > > > > > > > Any help on these issues would be greatly appreaciated. I know I > > > am > > > > > > > not the only one who has had trouble with them. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
