I'm no sure if cake's findAll function accepts arrays in the fields variable:
Try this, using the format Grant Cox suggested:
$this->Gallery->findAll("id = {$id}","Gallery.name,
Gallery.description, Image.filename");
At least in the API , they say 'fields' var must be a string :>
Spark
On 2/3/07, peper <[EMAIL PROTECTED]> wrote:
>
> I have no idea :-(
>
> $this->Gallery->findAll(
> "Gallery.id = '$id'",
> array('Gallery.name','Image.filename')
> );
> Doesn't work (returns FALSE), while
> $this->Gallery->findAll(
> "Gallery.id = '$id'"
> );
>
> and
>
> $this->Gallery->findAll(
> "Gallery.id = '$id'",
> array('Gallery.name')
> );
> works fine.
>
> The same is with:
>
> $this->Gallery->read(
> array('Gallery.name','Gallery.description','Image.filename'),
> $id );
>
> returns false while
>
> $this->Gallery->read(
> array('Gallery.name','Gallery.description'),
> $id );
>
> and
>
> $this->Gallery->read(
> null,
> $id );
>
> works OK.
>
> Models are extremely simple:
>
> class Gallery extends AppModel
> {
> var $name = 'Gallery';
> var $hasMany = array('Image' => array('className' => 'Image'));
> }
>
>
> class Image extends AppModel
> {
> var $name = 'Image';
> var $belongsTo = array('Gallery' => array('className' =>
> 'Gallery'));
> var $hasMany = array('Comment' => array('className' =>
> 'Comment'));
> }
>
>
>
>
> On Feb 3, 1:49 am, "Grant Cox" <[EMAIL PROTECTED]> wrote:
> > The problem is that "name" is ambiguous - do you mean the Gallery.name
> > or the Image.name ?
> >
> > As a convention, you should prefix all your fields with the model
> > name, so your query would be:
> > $this->Gallery->findAll("Gallery.id = '$id'",
> > array("Gallery.name","Gallery.description","Image.filename") );
> >
> > or even just
> > $this->Gallery->read(
> > array('Gallery.name','Gallery.description','Image.filename'),
> >
> > $id )
> >
> > as I assume your Gallery.id field is unique :)
> >
> > peper wrote:
> > > Hi.
> > > I'm new in CakePHP. My problem is:
> > > I've got Gallery(id,name,description) and
> > > Image(id,name,filename,gallery_id) models.
> > > When I make:
> > > $this->Gallery->findAll("id = '$id'");
> >
> > > I get a Gallery and related imges. Works fine. But I want only gallery
> > > name, description images filename, so I do:
> > > $this->Gallery->findAll("id = '$id'",
> > > array("name","description","Image.filename")
> > > );
> >
> > > and it returnes false :-(
> >
> > > What's wrong ?
>
>
> >
>
--
[web] http://synapsisdi.com.br
[livesets] http://djspark.com.br/mp3
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" 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
-~----------~----~----~----~------~----~------~--~---
