Hi everyone,
I have being trying to solve this for the last 4 hours with no luck.
basically I have the following tables
users
links
users_links
Basically I'm trying to get the below query to run using find('all')
and paginate (I'm running this inside UserController)
SELECT
If you have defined a HABTM relationship your joining table should be
links_users (i.e. the tables are in alphabetical order).
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 21 Jul 2011, at 16:26, localhost wrote:
Hi everyone,
I have being trying to solve this for the last 4
Sorry I didn't understand your reply
I have defined the relationship
class UsersLink extends AppModel {
var $belongsTo = array(
'Link' = array(
'className' = 'Link',
'foreignKey' = 'link_id',
This is one way I found it to be working with find('all') but not with
paginate ( due to the select count)
$this-User-recursive = -1;
$options['joins'] = array(
array('table' = 'users_links',
'alias' = 'UsersLink',
'type' = 'inner',
I think you are not following the conventions, are making life difficult for
yourself and should read the guide.
Jeremy Burns
Class Outfit
http://www.classoutfit.com
On 21 Jul 2011, at 17:05, localhost wrote:
Sorry I didn't understand your reply
I have defined the relationship
class
What is being said is that you have some conventions you didn't
follow. As a result, you are writing overly-complicated code to handle
what should be automatic within the framework.
Do this:
1) move / rename your users_links table and data to a links_users
table inside mysql.
2) remove
Hello!
I'm trying to get some data using habtm.
here is the code:
$this-Article-bindModel(array('hasOne'=array('ArticlesTag')));
$tags = $this-Article-Tag-
find('list',array('conditions'=array('ArticlesTag.article_id'=
$id)));
The source is from the manual.
Now the error:
Warning (512): SQL
For 1.2 but still applies:
http://marianoiglesias.com.ar/cakephp/modelizing-habtm-join-tables-in-cakeph
p-1-2-with-and-auto-with-models/
or
http://nuts-and-bolts-of-cakephp.com/2008/07/03/notes-on-cakephp-habtm-part-
1-the-basics/
Common mistake is in the name. Filename / classname / singular
Which model are you declaring this in? As it should logically be in
Parent or Student, but your controller logic looks as though you're in
Person. Until I can understand a little more about your models I cant
really offer much assistance.
Paul
Check out the new CakePHP Questions site
Hi guys,
I have a little annoying problem.
Habtm declaration:
'ParentsHasStudents' = array(
'className' = 'Parents',
'joinTable' = 'parents_has_students',
'foreignKey' = 'parent_id',
'unique' = false,
'associationForeignKey' = 'student_id'));
And Post Data:
[ParentsHasStudents] = Array
How can I get the related data in habtm in paginator .
I have auctions and categories . One auction HABTM category .
I want to get the auctions which has category with ID :
$data = $this-paginate('Project' ,array(
11 matches
Mail list logo