hi,
im playing around with the hasAndBelongstoMany. thats my table
structure.
TABLES
projects
id
projectTitle
tasks
id
description
projects_tasks
project_id
task_id
start_date
end_date
var $hasAndBelongsToMany = array('Task' =>
array('className' => 'Task',
'joinTable' =>
'projects_tasks',
'foreignKey' => 'project_id',
'associationForeignKey'=>
'task_id',
'conditions' => '',
'order' => '',
'limit' => '',
'unique' => true,
'finderQuery' => '',
'deleteQuery' => '',
)
);
DEBUG
SELECT Task.id, Task.description from tasks AS Task JOIN
projects_tasks ON (projects_tasks.project_id = 1 AND
projects_tasks.task_id = Task.id)
Everything works fine, BUT inside projects_tasks there are 2 more
fields "start_date", "end_date".
how can i include them also inside the query?
like this
SELECT Task.id, Task.description,projects_tasks.start_date,
projects_tasks.end_date from tasks AS Task JOIN projects_tasks ON
(projects_tasks.project_id = 1 AND projects_tasks.task_id = Task.id)
thanks for helping
pete
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
