HABTM again!
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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: HABTM again!
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 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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: HABTM again!
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',
'conditions' = '',
'fields' = '',
'order' = ''
),
'User' = array(
'className' = 'User',
'foreignKey' = 'user_id',
'conditions' = '',
'fields' = '',
'order' = ''
)
);
}
What do you mean by joining table should be links_users (i.e. the
tables are in alphabetical order) ?
On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
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 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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org
Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group
athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: HABTM again!
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',
'conditions' = array(
'User.id = UsersLink.user_id',
'UsersLink.inbox = 1'
)
),
array('table' = 'links',
'alias' = 'Link',
'type' = 'inner',
'conditions' = array(
'UsersLink.link_id = Link.id'
)
)
);
$options['fields' ] = array('Link.id', 'Link.title');
$inbox = $this-User-find('all', $options);
What do you think?
On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
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 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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org
Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group
athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: HABTM again!
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 UsersLink extends AppModel {
var $belongsTo = array(
'Link' = array(
'className' = 'Link',
'foreignKey' = 'link_id',
'conditions' = '',
'fields' = '',
'order' = ''
),
'User' = array(
'className' = 'User',
'foreignKey' = 'user_id',
'conditions' = '',
'fields' = '',
'order' = ''
)
);
}
What do you mean by joining table should be links_users (i.e. the
tables are in alphabetical order) ?
On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
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 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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org
Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group
athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
Re: HABTM again!
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 completely the model for your join table - the UsersLink
model.
3) define a normal habtm relationship between the User model and the
Link model.
4) read the manual before you start another project - all of this is
clearly explained in many translations.
On Jul 21, 10:45 am, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
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 UsersLink extends AppModel {
var $belongsTo = array(
'Link' = array(
'className' = 'Link',
'foreignKey' = 'link_id',
'conditions' = '',
'fields' = '',
'order' = ''
),
'User' = array(
'className' = 'User',
'foreignKey' = 'user_id',
'conditions' = '',
'fields' = '',
'order' = ''
)
);
}
What do you mean by joining table should be links_users (i.e. the
tables are in alphabetical order) ?
On Jul 21, 6:31 pm, Jeremy Burns | Class Outfit
jeremybu...@classoutfit.com wrote:
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 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 Links.id,Links.Title FROM users,links,users_links WHERE
user.id=1 AND user.id=users_links.user_id AND
users_links.link_id=links.id AND users_links.index=1
(see the above sql users_links.index=1).
how to get this working ?
--
Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org
Check out the new CakePHP Questions sitehttp://ask.cakephp.organdhelp
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group
athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video
Tutorialshttp://tv.cakephp.org
Check out the new CakePHP Questions sitehttp://ask.cakephp.organd help
others with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group
athttp://groups.google.com/group/cake-php
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
HABTM... again
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 Error: 1054: Unknown column
'ArticlesTag.article_id' in 'where clause' [APP\cake\libs\model
\datasources\dbo_source.php, line 681]
Query: SELECT `Tag`.`id`, `Tag`.`name` FROM `tags` AS `Tag` WHERE
`ArticlesTag`.`article_id` = 36
I just can't figure out what's wrong. What am i missing? i read the
manual + some blog entries about habtm but i don't feel like i'm
closer to the goal.
Another thing: When one record from articles table is deleted
(trough cake), all of the joins are deleted too. Help me!
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at
http://groups.google.com/group/cake-php
RE: HABTM... again
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 (plural mixup). Also with = some_join_table parameter another option. K -- Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions. To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php
Re: Habtm again
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 http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
Habtm again
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 ( [0] = Array ( [student_id] = 1 ) [1] = Array ( [student_id] = 5 ) command $this-Person-saveAll($this-data) is ovveriding first student_id data by UPDATE: UPDATE `parents_has_students` SET `student_id` = 5, `parent_id` = 299 WHERE `parents_has_students`.`parent_id` = 299 How correct this return into INSERT? Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups CakePHP group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en To unsubscribe, reply using remove me as the subject.
HABTM again
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(
'Auction.status'='open',
'Auction.approved'=1,
'What wil be here'
)
);
Thanks in advance .
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
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
-~--~~~~--~~--~--~---
