Hello all, I am trying to search from a modal and search a model that is associated to it. I have two models.
User hasMany Friends Friend belongsTo User Basically, in the User model, if someone enters the search term 'Tom', I want to be able to search for Users named Tom and Friends that are named Tom. Right now I keep getting "1054: Unknown column 'Friend.name' in 'where clause'" I looked into containable and tried tons of examples over the web but couldn't get it working. I am trying to paginate this as well, but that is an after thought. I can't get this done in a single query. Anyone know how to search over a hasMany association? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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 -~----------~----~----~----~------~----~------~--~---
