I am using version 0.10.9.2378_final and am trying to run
pre
$this-set('events',
$this-Event-findBySql(SELECT * FROM events AS Event, pages AS
Page
WHERE
Page.id=Event.page_id AND (
(Page.url LIKE '{$this-pageInformation['url']}' AND
Set debug to 2 to see what your query looks like.
If you query looks good, copy the query that debug displays and run in
phpmyadmin.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups Cake
PHP group.
To post to this
I set the debug to 2 and it looks ok. I run it in SQLyog (like
phpmyadmin) and it returns 2 rows.
The array that is returned in cake is:
Array
(
[0] = Array
(
[Event] = Array
(
[id] = 2
[page_id] = 2