Hi
I've just installed the latest stable 1.2 version of CakePHP on my
Ubuntu 8 server running PHP 5.2.4 and MySQL 5.0.51a.
I've followed the Blog 1.2 tutorial as far as creating a model and a
controller for a table called competitors. However now that I've the
controller created when I run the .../competitors/index URL the model
reports a syntax error in the SQL.
Here's my model:
[code]
<?php
class Competitor extends AppModel {
var $name = 'Competitor';
}
?>
[/code]
Here's my controller:
[code]
<?php
class CompetitorsController extends AppController {
var $name = 'Competitors';
function index() {
$this->set('competitors', $this->Competitor->find
('all'));
}
}
?>
[/code]
and here's the syntax error I get back:
[code]
Query: SELECT `Competitor`.`id`, `Competitor`.`competitor_name` FROM
`wl_competitors` AS `Competitor` WHERE all LIMIT 1
Warning: SQL Error: 1064: You have an error in your SQL syntax; check
the manual that corresponds to your MySQL server version for the right
syntax to use near 'all LIMIT 1' at line 1 in /var/www/winloss/flan/
cake/libs/model/datasources/dbo_source.php on line 439
[/code]
Now I don't have a view defined yet; but I don't believe this is the
cause of the problem. As the method should be finding all records it
shouldn't be introducing a WHERE clause at all, let alone one with a
syntax error.
So what have I done wrong?
Thanks
David
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
