The fact that it is returning false for both the Model::findAll and
$this->paginate, that indicates that it isnt able to complete the sql
statement when retrieving data doesnt it? Actually.........

Ok, not sure why i didnt thnk of it before, but I have just upped the
debug mode, and found that one of the field names was incorrectly
spellt, so it wasnt able to pull from the db. Wow, I can't believe how
long that has taken to find that out.

Thanks for your help with this, sorry that it was my simple mistake :
(

Patrick


On Jul 10, 6:01 am, AussieFreelancer <[EMAIL PROTECTED]>
wrote:
> Ok, just tried that and same result, there is nothing in my <pre></
> pre> tags. I'm guessing this is because it isnt an array, but a
> boolean false? There are definitely records in the db.
>
> On Jul 10, 12:10 am, jhicks <[EMAIL PROTECTED]> wrote:
>
> > Try this instead and see what happens:
>
> > $this->set("data", $this->paginate('AcumarcBuilding'));
>
> > and then pr($data) in your view (if you aren't already).
>
> > On Jul 9, 7:44 am, AussieFreelancer <[EMAIL PROTECTED]>
> > wrote:
>
> > > hmm, and what is also weird is that when i do this,
>
> > > $this->data = $this->AcumarcBuilding->read(null, $building_id);
>
> > > then debug($this->data), that is blank also. i just dont understand
> > > what is going on, or what i could have done for it to stop working.
>
> > > On Jul 9, 9:21 pm, AussieFreelancer <[EMAIL PROTECTED]>
> > > wrote:
>
> > > > definitely data in the table, and have just tried a var name different
> > > > to data, but no difference.. thanks for the prompt reply...
>
> > > > On Jul 9, 9:15 pm, "Jonathan Snook" <[EMAIL PROTECTED]> wrote:
>
> > > > > Are you sure you have content in that table? (although it'd normally
> > > > > return an empty array rather than false but something to think about)
>
> > > > > Secondly, maybe use a different variable besides $data. It shouldn't
> > > > > matter but I'd be likely to try it anyway.
>
> > > > > On Wed, Jul 9, 2008 at 8:57 AM, AussieFreelancer
>
> > > > > <[EMAIL PROTECTED]> wrote:
>
> > > > > > hi all, i have spent some stupid hours on this, and still cant work
> > > > > > out what is going on...
>
> > > > > > I have this code:
>
> > > > > > var $paginate = array(
> > > > > >                        'AcumarcBuilding' => array(
> > > > > >                                'limit'         => 25,
> > > > > >                                'order'         => array(
> > > > > >                                        'AcumarcBuilding.id' => 'asc'
> > > > > >                                )
> > > > > >                        )
> > > > > >                );
>
> > > > > > then:
>
> > > > > > $data = $this->paginate('AcumarcBuilding');
> > > > > >                        $this->set(compact('data'));
>
> > > > > > but, the variable $data in the view, is a boolean and is set to 
> > > > > > false.
> > > > > > What is going on?? This is the second controller that has done this
> > > > > > now, and need to get this sorted urgently :( Any help would be 
> > > > > > greatly
> > > > > > appreciated.
>
> > > > > > Thanks
>
> > > > > > Patrick
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to