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 -~----------~----~----~----~------~----~------~--~---