Just to clarify, I added the debugger message:
Generated query from cake:
SELECT `Treeview`.`id`, `Treeview`.`prev`, `Treeview`.`filename`,
`Treeview`.`fileExtension`, if(fileExtension='0', filename,
concat(filename, '.', fileExtension)) AS fullfilename,
`Treeview`.`folder` FROM `treemenu` AS `Treeview` WHERE
(`Treeview`.`id` != '58') AND (`Treeview`.`folder` = '0') AND
(`Treeview`.`prev` = '1') AND ((`fullfilename` = 'pager.html')) AND
(`Treeview`.`prev` = '1')
Error from cake:
1054: Unknown column 'fullfilename' in 'where clause'
The query should be:
SELECT `Treeview`.`id`, `Treeview`.`prev`, `Treeview`.`filename`,
`Treeview`.`fileExtension`, if(fileExtension='0', filename,
concat(filename, '.', fileExtension)) AS fullfilename,
`Treeview`.`folder` FROM `treemenu` AS `Treeview` WHERE
(`Treeview`.`id` != '58') AND (`Treeview`.`folder` = '0') AND
(`Treeview`.`prev` = '1') HAVING ((`fullfilename` = 'pager.html'))
Any idea what is wrong with my query definition?
$queryArray = array(
"$controllerName.id" => "!=
$id",
"$controllerName.folder" => 0,
"$controllerName.prev" =>
$fileData[0][$controllerName]["prev"]
,"having" =>
array("fullfilename" => "pager.html")
);
Thank your any help!
On Mar 7, 1:54 pm, "Aldo" <[EMAIL PROTECTED]> wrote:
> Yes, this way I get the value.
> But building the query cake seams not to find the column
> 'fullfilename' and not build the 'HAVING' right.
>
> the finished sql query should look like this:
> select id, prev, filename, fileExtension if(fileExtension='0',
> filename, concat(filename, '.', fileExtension)) AS fullfilename from
> treeview where id!=58 AND folder=0 AND prev=1 HAVING fullfilename =
> 'skyline.jpg'
>
> But like showed in the post before this part of the statement in cake
> seams to cause an error:
> "having" => array("fullfilename" => "skyline.jpg")
>
> So the problem is not getting the value of 'fullfilename', it's
> setting the filed 'fullfilename'.
>
> Any idea? Thanks!
>
> On Mar 7, 1:26 pm, "Sergei" <[EMAIL PROTECTED]> wrote:
>
> > You should access it like:
>
> > $fileData[INDEX_HERE][0]["fullfilename"]["prev"]
>
> > like a:
>
> > $fileData[0][0]["fullfilename"]["prev"]
>
> > On 7 мар, 16:11, "Aldo" <[EMAIL PROTECTED]> wrote:
>
> > > Hi Zoltan
>
> > > Thank you.
> > > But do you know a workarround for this:
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
