If I just run find all, then everything is fine I get data back in the format below which is fine; however, if I pass in fields (only need 3 fields from all that information) as in the previous email examples is says that it doesn't know the table.field? Why is this?
How do I get the information below, but create a custom column like DateDiff(Package.created, now()).
Array
(
[0] => Array
(
[Package] => Array
(
[id] => 2
[created] => 2008-12-24 10:48:39
[modified] => 2008-12-24 11:39:17
[name] => Welcome A - 2 day
[mailing_id] => 1
[interval] => 2
)
[Mailing] => Array
(
[id] => 1
[created] => 2008-12-24 10:47:40
[modified] => 2008-12-24 10:47:40
[name] => Welcome A
[description] => Welcome Letter
[weight] => 1.25
[us_shipping] => .42
[mex_shipping] => 1.23
[int_shipping] => 4.50
)
[Sequence] => Array
(
[0] => Array
(
[id] => 2
[created] => 2008-12-26 14:14:05
[modified] => 2008-12-26 14:14:05
[name] => Sequence Trial 2
[PackagesSequence] => Array
(
[id] => 3
[package_id] => 2
[sequence_id] => 2
)
)
)
)
)
Thanks,
Chad
On Sat, Dec 27, 2008 at 11:18 AM, Webweave <webweave@gmail.com> wrote:
Your original post showed 'uses' for the tables in question, which
infers that you don't have them linked to the controller's model.
If they are connected, you may not have recursive set properly to
cause Cake to include them. Cake needs to understand how the tables
get joined in order to build the SQL.
On Dec 27, 6:45 am, "Chad Casselman" <ccassel...@gmail.com> wrote:
> Even though the binding is in the models correctly, I have to respecify the
> associations in this controller that are already in the models that are
> being "used"? Assuming that that HABTM is not going to be a problem.
>
> Chad
>
> On Fri, Dec 26, 2008 at 11:11 PM, Webweave <webwe...@gmail.com> wrote:
>
> > In order to fetch data from both tables, you need to join them, Cake
> > won't do this automagically.
>
> > On Dec 26, 5:40 pm, "Chad Casselman" <ccassel...@gmail.com> wrote:
> > > Should it bring in all hardcoded (model) associations when I import them?
>
> > > Here is what I have and I can't pull any fields from Sequences or
> > > PackagesSequence objects/tables
>
> > > var $uses = array('Package','Sequence','PackagesSequence');
> > > $extra = array(
> > > 'recursive' => 1, //int
> > > 'fields' => array('Package.name', 'Sequence.name'),
> > //array
> > > of field names
> > > );
>
> > > $this->Package->find('all', $extra);
>
> > > I get an error that it doesn't know the Sequence table. Thoughts? Do I
> > > have to recode the associations already in the models?
>
> > > Chad
>
> > > On Fri, Dec 26, 2008 at 6:26 PM, Arthur Pemberton <pem...@gmail.com>
> > wrote:
>
> > > > On Fri, Dec 26, 2008 at 5:14 PM, Chad Casselman <ccassel...@gmail.com>
> > > > wrote:
> > > > > I have a Controller for Jobs with a model Job.
>
> > > > > When I hit /jobs (the index function of Job Controller), I need to
> > run a
> > > > > query on 2 other tables (not joined to Job) to find values to
> > manually
> > > > > insert into jobs before actually displaying the index.
>
> > > > > I have tried several things but can't seem to make any progress on
> > this.
>
> > > > > Can anyone help me with this?
>
> > > > > 1) select fields from a join on customers and packages (complex
> > > > conditions)
>
> > > > I believe you want to bind those models to each other [1]
>
> > > > > 2) iterate through results and insert/update values in job
>
> > > > Once you setup the appropriate bindings, you can do a find('all') on
> > > > them and iterate over the results of that. [2] may be clearer.
>
> > > > > 3) display jobs
>
> > > > I'm guessing that part already works with your index() action.
>
> > > > > Thank you in advance.
>
> > > > > Chad
>
> > > > [1]
> > > >http://book.cakephp.org/view/86/Creating-and-Destroying-Associations-.
> > ..
> > > > [2]http://book.cakephp.org/view/83/hasAndBelongsToMany-HABTM
>
> > > > --
> > > > Fedora 9 : sulphur is good for the skin
> > > > (www.pembo13.com)
>
>
--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
No comments:
Post a Comment